At 09:42 AM 15/11/2004 +1300, you wrote:

>Hi All
>
>I am sure this really easy but here goes.
>
>I have lots of scenarios where I do an SQL (may be complex) and then work
>with the results, however I often want to check that a record has been
>returned. My code has used recordCount for this, however I believe that to
>do this with IBO components the components must run an SQL with the
>equivalent of a Count(). I don't want to do this. What is the best
>alternative, just check EOF?

Never use counts!! Use the IsEmpty property for queries; for ib_cursors,
call First and then check EOF.

Helen