Forum Discussion

Adagio's avatar
Adagio
Frequent Contributor
8 years ago

How to check if a recordset is null

Hello,

 

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.)? 

 

Please refer to the snapshot.

 

 

Any help would be appreciated! 

 

Thank you

Abhi

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

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor

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

    • Adagio's avatar
      Adagio
      Frequent Contributor

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