You can't. If you do a select it will expect it to be a singleton select and
raise an exception. If there is more than one record it will raise and
exception too.

Use a cursor and call First and then check to see if it is EOF. If not then
just ignore the returned record.

Jason Wharton

-----Original Message-----
From: Ronan van Riet [mailto:ronanvanriet@...]
Sent: Monday, July 26, 2004 10:22 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] check for empty dataset


Hello,

How can I use TIB_DSQL to determine whether the dataset is empty or not?

Thanks,
Ronan