Subject RE: [ib-support] Record Count
Author Mike Grover
This is not using IBComponents, ODBC Query, Using a count() means I have to query twice :-( , Very time consuming on large queries..


-----Original Message-----
From: Woody [mailto:woody.tmw@...]
Sent: Wednesday, November 07, 2001 2:26 PM
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.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Universal Inkjet Refill Kit $29.95
Refill any ink cartridge for less!
Includes black and color ink.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to