At 04:17 AM 2/03/2006, you wrote:

>As soon as I used ExecSQL it worked ok, I need to readup on the
>difference between Open & ExecSQL.

That one is just tooooo simple. If your SQL statement starts with
SELECT, you use Open (or, in the case of IB_Cursor, First).

All other SQL statements, use Execute.

Btw, don't use IB_Query/IBOQuery for executable statements. Use
IB_DSQL (best) or IB_Cursor. Because executable statements are not
linked to visual controls, there's no problem using these components
with TIBODatabase as their IB_Connection.

Helen