using queries in functions (Store Procedures)

[samson]

Hi all,

Code:

if not exists (select l.Locality from TgnTerritorydtl tdtl, tgnLocality l, Tgncompany C where l.localityid= tdtl.localityid and c.companyid=l.companyid and c.company='company' and l.Locality='123') print 'WARNING: Locality not Exists' else Print 'Locality Exists'

now my issue is : How do i use this type of query or store procedure in QTP 10,
Note: while creating DBcheckPoint it could not create. and while pasting this in function too QTP 10 shows errors, so how do i do , if kindly help,
Waiting for the reply thank you.
Note 1: while replacing print with MsgBox too errors were found.
Thank you,
Samson.B

[Saket]

Hi Samson,
you can not directly use a query to put in if condition.
you will need to exceute these query and compare the recordset.

steps you can follow -
1 connect to DB
2 execute your query
3 get the recordset
4 then compare the values

e.g in your case here

Code:

Dim oConnection,ConnectionString , oRecordSet ConnectionString ="<Connection string to Connect to DB>" 'refer https://www.learnqtp.com/qtp-database-part2-how-to-create-connection-strings/ Set oConnection = CreateObject("ADODB.Connection") Set oRecordSet = CreateObject("ADODB.Recordset") oConnection.Open ConnectionString strSQL = "select l.Locality from TgnTerritorydtl tdtl, tgnLocality l, Tgncompany C where l.localityid= tdtl.localityid and c.companyid=l.companyid and c.company='company' and l.Locality='123'" oRecordSet.Open strSQL,oConnection, adOpenStatic if oRecordSet.Fields("Locality").value <> null then 'or you can get the record count here if > 0 then locality exists print "Locality Exists" else print "Locality Not Exists" end if

while creating DBCheckpoint put the same query there.