Subject | Query returning no rows |
---|---|
Author | jkkotze@yahoo.com |
Post date | 2001-06-15T10:05:10Z |
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
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