QTP Versions

Versions

11.0 Beta - 2010
10.0 - Released in 2009
9.5 - Released in 2007
9.2 - Released in 2007
9.0 - Released in 2006
8.2 - Released in 2005
8.0 - Released in 2004
7.0 - Never released.
6.5 - Released in 2003
6.0 - Released in 2002
5.5 - First release. Released in 2001

VBscript to retrieve BLOB data type

BLOB data type: 


A BLOB (binary large object) is a varying-length binary string that can be up to 2,147,483,647 characters long. Like other binary types, BLOB strings are not associated with a code page. In addition, BLOB strings do not hold character data.

You can use a BLOB data type to store any data that a program can generate: graphic images, satellite images, video clips, audio clips, or formatted documents saved by any word processor or spreadsheet. The database server permits any kind of data of any length in a BLOB column. 

Like CLOB objects, BLOB objects are stored in whole disk pages in separate disk areas from normal row data.

The advantage of the BLOB data type, as opposed to CLOB, is that it accepts any data. Otherwise, the advantages and disadvantages of the BLOB data type are the same as for the CLOB data type.

 
VBscript to read BLOB:

'Create the connection, recordset & stream objects
set oCon = CreateObject("ADODB.Connection")
Set oRs = CreateObject("ADODB.Recordset")
set mstream = CreateObject("ADODB.Stream")
mstream.Type = 1 'adTypeBinary
'Open SQL connection
oCon.Open pstr
oRs.CursorType = 0 'adOpenForwardOnly
sql="select Data_Value from <Table_Name> where <Variable>"
'Run the Query
oRs.open sql,oCon
'oRs.MoveFirst
Do While Not oRs.EOF
If oRs.Status = adRecModified Then
mstream.Open
mstream.Write oRs("Data_Value")
mstream.SaveToFile <FileName>, 2 'adSaveCreateOveWrite , also tried
mstream.close
End If
oRs.MoveNext
Loop
oRs.close
oCon.Close
Set oRs = Nothing
Set oCon = Nothing
set mstream=Nothing

Blogger Labels: VBscript,BLOB,data,length,addition,satellite,processor,database,server,column,CLOB,disk,areas,advantage,Otherwise,advantages,disadvantages,Create,connection,CreateObject,ADODB,Recordset,Stream,Type,Open,CursorType,Data_Value,Table_Name,Variable,Query,MoveFirst,Status,Write,SaveToFile,FileName,MoveNext,Loop,Close,oCon,mstream

Vbscript to post xml to Webservice…

Web service Define:

The term often refers to an interface for service oriented architecture (SOA),in which Web-based applications dynamically interact with other Webapplications using open standards that include XML running over HTTP, UDDI andSOAP. Such applications typically run behind the scenes, one program"talking to" another (server to server). Microsoft's .NET and Sun'sJava System (J2EE) are the major development platforms that natively supportthese standards.

VB Script to post xml to web service

Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile(sFileName, 1, True)

l1 = CreateObject("M
RequestXML=f.ReadAll
'Load the XML DOM
Set x
microsoft.XMLDOM")
xml1.async = False
call xml1.Load (sFileName)

l2.XMLHTTP")
call XslHttp.open("
'Post the XML to the web service
set XslHttp = CreateObject("Msx
mPOST",ServerURL, false,"","")
call XslHttp.setRequestHeader("content-type","text/xml")

fso = CreateObject("Scripti
call XslHttp.send(xml1.xml)
ACK_Res = XslHttp.ResponseText
'Return the response XML
Set
 ng.FileSystemObject")
Set f = fso.OpenTextFile(sAckPath + trim (" \Res") & ".xml", ForWriting, True)


f.Write ACK_Res
f.close
set f= Nothing
set fso=Nothing


set xml1 = Nothing

Blogger Labels: Vbscript,Webservice,Define,interface,architecture,Webapplications,UDDI,server,Microsoft,SunJava,System,development,platforms,Script,CreateObject,FileSystemObject,OpenTextFile,True,RequestXML,ReadAll,Load,XMLDOM,False,Post,XslHttp,XMLHTTP,ServerURL,text,ACK_Res,ResponseText,Return,response,Write,sFileName