I execute a stor proc using TIBOQuery. The stor proc inserts a new
record in a table. The transaction used by the query has autocommit set
to true. I cannot see the new record (in IBConsole) until I execute the
query again or close the app.

The stor proc returns a value, and if it cannot find one it creates a
new record and returns the number for it.

If I call commit then I can see the record in IBConsole.

Is it due to the fact that I'm using TIBOQuery to execute a stor proc ?

Regards

Sandeep