If the Bof is true and the Eof is true then there is nothing in the dataset
perhaps ?

Regards
Norman.

------------------------------------------------------------------------
--------
Norman Dunbar EMail: NDunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. Fax: 0113 201 7265
URL: http://www.LynxFinancialSystems.com
------------------------------------------------------------------------
--------




-----Original Message-----
From: jkkotze@... [mailto:jkkotze@...]
Sent: Friday, June 15, 2001 11:05 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Query returning no rows


What is the best way to determine if a query returned no rows at all.
I am using the following method, but it gives me an error:

dbTest.Active := False;
dbTest.Filter := {my filter string};
dbTest.Filtered := True;
dbTest.Prepare;
dbTest.Open;
dbTest.First;
While Not(dbTest.Eof) do
Begin
{do my processing}
dbText.Next;
end;

The error I receive is the following:
ISC ERROR CODE:335544374 ISC ERROR MESSAGE: attempt to fetch past the
last record in a record stream

I am using version 3.6Dg of IBO

Johan Kotze





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/