Subject Re: [IBO] Correct way to use TIB_Cursor
Author William J Hill
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