This is not using IBComponents, ODBC Query, Using a count() means I have to query twice :-( , Very time consuming on large queries..

mike

-----Original Message-----
From: Woody [mailto:woody.tmw@...]
Sent: Wednesday, November 07, 2001 2:26 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Record Count


From: "Mike Grover" <mike@...>

> Is there a way to get a record count from a query and
> have the data to?
>

If you are using IBX components, do a FetchAll. Or, you can do a Last, then
First to set the recordcount properly. This does take time witha a larger
result set, though. A better way, if your query is not real complex is to
use something like a Count(*) in a separate query first.

Woody


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Universal Inkjet Refill Kit $29.95
Refill any ink cartridge for less!
Includes black and color ink.
http://us.click.yahoo.com/ltH6zA/MkNDAA/ySSFAA/dpFolB/TM
---------------------------------------------------------------------~->

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/