Hello,

As I can recall when you do a tQuery.RecordCount it forces the BDE to fetch
all the rows, what can be a little slow, I think using ADO do the same
thing, I don't know about IBO or FIBPlus.

Another aproach is:

Create a function that parses the statment and changes it like this:

Select Name, Phone from Customers where City like 'Salt Lake%'

change it to:

Select count(*) from Customers where City like 'Salt Lake%'

and returns the value as the function result.

I think it could be more reliable.

HTH

Alexandre

At 12:12 09/04/02 -0600, you wrote:

>T..Query.Open
>
>T..Query.RecordCount seems to work fine for me
>
>---------------------------------------
>
>Daniel Bertin wrote:
> >
> > Hi all,
> >
> > How would I assign to a variable the number of rows the query has currently
> > returned?
> >
> > Var := Result of a query with the number of rows.
> >
> > Suggestions would be greatly appreciated
> > Thanks
> > Daniel
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/