01-19-2014, 11:32 PM
Hi all! I'm the beginer in QTP, can you please help me with Database CheckPoint.
I create a connection and RecordSet:
then I create the connection string and recordset:
And I have created the checkpoint table (from database). I saved it in local repository. Tell me please, how can I compare the result of my SQL query with my checkpoint table? I don't understand. Where is my temporary table which called by RecordSet?
I create a connection and RecordSet:
Code:
Set objConn = CreateObject("ADODB.Connection")
Set objRecSet = CreateObject("ADODB.Recordset")
then I create the connection string and recordset:
Code:
connstr = "something..."
strQuery ="select * from * where * and *"
objConn.Open connstr
objRecSet.Open strQuery, objConn
And I have created the checkpoint table (from database). I saved it in local repository. Tell me please, how can I compare the result of my SQL query with my checkpoint table? I don't understand. Where is my temporary table which called by RecordSet?