Re:Is there a way to run a query against the result set another query
Not really. With the BDE you can make a permanent table out of the result set,
but in this case there isn't really an easy way to do this.
As for record count, most SQL backends don't return record counts. With IBX,
RecordCount will reflect the number of records brought across to the client
side, so in some situations where the query is long running, doing a FetchAll
will fetch all the records across and RecordCount will then reflect the real
count.
Quote
M Tuttle wrote:
> Greetings All,
> Currently I have to query my database twice. One for the actual result set
> and another returning the count of the result set. Both queries have the
> exact same SQL statement with the exception of the count query which uses
> something like:
> SQL.Add('Select count(*) from Employer E ' +
> 'LEFT OUTER JOIN Emp_Address EA ON EA.Emp_ID =
> E.Emp_ID '+
> 'and EA.Addr_Type_Code = "P" ' +
> 'and EA.Default_Address = 1 ' + SQLText);
> Is there anyway to run a query that counts records against the first query
> that returns the actual result set?
> Seems to me would be much faster than actually querying the same table
> twice.
> Or better yet, why doesn't the RecordCount property of an IBQuery return the
> record count?
> Any help would be appreciated.
> Thanks
> Mike
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus. (Fish)
