Thanks Helen.

Knew it would be something simple :)

Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: Helen Borrie
To: IBObjects@yahoogroups.com
Sent: Monday, November 15, 2004 11:53 AM
Subject: Re: [IBO] Question about structure


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




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]