Subject Re: [ib-support] Record Count
Author Woody
From: "Nando Dessena" <nandod@...>
>
> IBO does this automatically when a call to RecordCount is made (and it
> actually works).

Yes I know it does, but many people don't use IBO, just IBX.

> Just hope you don't have the word 'from' in any of the select field
> names, and that your select does not use a distinct clause or
> aggregates, as this approach would fail.
> Years ago I hit this kind of problems and I had to rewrite my
> SQL-manipulating functions to do real parsing, that's why I am warning
> you.

That's why I warned that it can only be used with the more simplistic
queries, not complex ones. You would need to build a separate query for
those.

Woody