Subject | Re: [IBO] Query returning no rows |
---|---|
Author | Jason Wharton |
Post date | 2001-06-15T10:04:25Z |
From the information given it looks like you should be OK.
What does the SQL monitor reveal?
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
What does the SQL monitor reveal?
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: <jkkotze@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, June 15, 2001 3:05 AM
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/
>
>