Thomas wrote:

> This is because of the PHP default transaction, which is automatically
> committed or rolled back on script termination.

Not really because of that. Read more carefully ;)

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

The stored produre DID write the record. Reading this, my guess is that
you are using isql to monitor table, and PHP to do the work. So when you
do SELECT in isql, you are in transaction until you "commit" it. If you
do SELECT in isql and then run something from PHP, it will be written to
database, but you won't see it from isql, since it didn't exists at the
time you started isql transaction. That's why you have to commit, and
next select (new transaction) shows data.

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net