Micro Focus QTP (UFT) Forums
Database CheckPoint - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Database CheckPoint (/Thread-Database-CheckPoint--7821)

Database CheckPoint - Luanna - 01-19-2014

Hi all! I'm the beginer in QTP, can you please help me with Database CheckPoint.
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?

RE: Database CheckPoint - Luanna - 01-21-2014

I have import Database Table into Data table like in https://www.learnqtp.com/qtp-database-checkpoint-part3-retrieving-data/, but I don't know how to compare this with my checkpoint table.