Hi,

I am using a Creole driver (written by me) to connect to a Firebird
database and call SPs.

The sequence of operations is the following (via the driver classes):

ibase_pconnect to the DB
ibase_prepare a query for calling the SP
ibase_execute with the query parameters
navigate the result set
ibase_free_result_set
ibase_free_query
ibase_commit
ibase_close

However, when subsequently trying to edit the called SP from the
Firebird client, the client issues a warning saying that the SP is in
use.

Since I am closing everything I used, I do not know where the problem
originates. Might there be some default started transactions that must
be closed or smth like this? Is it something in the interbase PHP
driver?

Thank you for your help.

=====

luxi




__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail