How to check if a recordset is null

Question

Hello,&nbsp;After establishing a connection between TestComplete and Db2, I ran a query which didn't return any results.How can I verify if the recordset is null (i.e. not records have been returned in the result set.)?&nbsp;&nbsp;Please refer to the snapshot.&nbsp;&nbsp;Any help would be appreciated!&nbsp;&nbsp;Thank youAbhi

tristaanogre · Accepted Answer

I would check EOF before you do the move first...&nbsp; if EOF is true, then there are no records

adagio · Answer

Thank you, Robert! I tried something similar and it worked.

Forum Discussion

How to check if a recordset is null

2 Replies

Related Content

Check whether object is (Null Object)

ado recordsets wrong with datatype text

Array null values

Python - Using ADO and RecordSet in testcomplete scripts

Checkpoints on recordsets with multiple tables

Recent Discussions

TestComplete14.72 is not recognizing WinUI-3 objects

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout