Hi.

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

Just use single transactions for your queries, that should do the trick,
so like:

$tr = ibase_trans(IBASE_COMMITTED, $conn);
ibase_execute($tr, "SOMETHING WITH YOUR SP");
ibase_commit($tr);

$tr = ibase_trans(IBASE_READ, $conn);
ibase_execute($tr, "SELECT STUFF");
ibase_commit($tr);

Hope that helps.

Thomas

Almond wrote:

> Hello all.
>
> 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 ?
>
> Best regards,
>
> Almond Wong
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>