At 06/10/2002 05:14 PM, you wrote:

>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.

Is the property ServerAutoCommit:=True as well? In the Transaction
component, you have the properties AutoCommit and ServerAutoCommit, make
sure both are set to true.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)