Hi Almond,

> I insert a record through a "execute procedure" query in PHP, and I found
> that the new inserted
> record cannot be retrieved until I execute a "commit" through isql.
>
> Is that I can force the write in a stored procedure ?

Yes, by doing a COMMIT on the transaction that's being used by
the procedure.

All database access in Firebird is done through a transaction.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com