I now have various tables and I would like in code to search for a particular item in a product table using a supplied barcode.

Thus the sql

select * from product WHERE BARCODE = 0000003000

does work.

BARCODE will be a variable, I know I need to use params and prepare, but I am a little overwhelmed by the number of properties in a TIB_Cursor.

Can anybody walk me through the correct configuration of a TIB_Cursor to perform the above.

Thanks in advance.

Rgds

Peter

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