Ok, thanks. I'll play with some test data.

Malcolm Smith
MJ Freelancing
http://www.mjfreelancing.com
C++Builder Software Protection


-----Original Message-----
From: Svein Erling Tysvaer
[mailto:svein.erling.tysvaer@...]
Sent: Tuesday, 10 September 2002 00:08
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Cursors


Oops, Helen is of course right in that you should use First and not Open. I
do this all the time in my own code and I never use Open myself, just when
answering you - sorry for that stupid mistake. The difference is that
Prepare is very time consuming and I think 500 prepares is more than enough
for it to be visible.

Set

>Thanks.
>
>What is so different that makes Open/Close more efficient that
>Prepare/Execute/Close ?

___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/