Subject Re: [IBO] RecordCount
Author Jason Wharton
Your sample was modified.

See the FetchAll instead of Last?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Walter Fordham" <walter@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, November 29, 2000 12:29 PM
Subject: RE: [IBO] RecordCount


> Was there something to come after the "this:" ? Or were you saying my
> example was more explicit?
>
>
> It's more explicit to do this:
>
>
> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Wednesday, November 29, 2000 2:12 PM
> To: IBObjects@egroups.com
> Subject: Re: [IBO] RecordCount
>
>
> It's more explicit to do this:
>
> > var q:TIBCursor;
> > total_records:integer;
> > begin
> >
> > with q do begin
> > sql.add('SELECT * FROM TABLE1');
> > open;
> > FetchAll;
> > total_records:=RowNo;
> > end;
> >
> > end;
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
>
>
>
>
>
>
>
>
>