Almond wrote:

> The select query is following the insert inside php. Except that the insert
> is through a stored procedure and not a query.
>
> The process is like that.
>
> 1. Insert the record through stored procedure in php.
> 2. The next query to get the new record in php failed.

What exactly does "failed" mean? Did you get some error message? Or you
didn't get a new record?

> 3. I open an isql console and execute the same query used in php.

Both queries, I guess?

> 4. isql still didn't get the query result.
> 5. Execute 'commit' in isql.
> 6. Re-run the query, the new record appear.

If I understood you correctly, then this behaviour it really strange.
Can you send your stored procedure? Also, how do you call procedure
(with SELECT FROM proc. or EXECUTE proc.).

> I remember there is an auto-commit option, how to set ?

AFAIK, It's only for DDL statements, and it is ON by default, so that is
not the problem.

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