----- Original Message -----
From: William J Hill
To: IBObjects@yahoogroups.com
Sent: Tuesday, August 12, 2003 9:07 PM
Subject: Re: [IBO] Correct way to use TIB_Cursor


Hello Peter,

> select * from product where BARCODE = :BARCODE
>
> With Product_IB_Cursor do
> begin
> Close;
> Prepare;
> ParamByName('BARCODE').AsString := Barcode;
> Open; // run query
> end;
>
>
> It does work, please can someone confirm that this is the recommended way
> to do this type of thing before I move onto edits.

Yes, but

1) Dont use .Open with a cusor, use .First instead.
2) If this query is live then make sure keyLinks are set.

hth,
William



Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
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 the Yahoo! Terms of Service.


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