Subject | insert_id() for Interbase/Firebird |
---|---|
Author | Ard Biesheuvel |
Post date | 2004-06-09T23:00Z |
Hello group,
I have a preliminary version of an ibase_insert_id() function that
emulates the behaviour of mysql_insert_id() in Firebird. If some
conditions are met, it is possible to query the database for the last
assigned value. (Uncommitted snapshot transaction, the table has a field
which is a singular primary key, the field has a 'before insert' trigger
associated with it that is also associated with a generator, and the
most recent operation was an INSERT and it didn't affect more than one
record)
If anyone is interested, I'll be adding this to PHP5 as soon as its
first release is final. This would mean the function can be available in
PHP 5.1
Comments anyone?
--
Ard
I have a preliminary version of an ibase_insert_id() function that
emulates the behaviour of mysql_insert_id() in Firebird. If some
conditions are met, it is possible to query the database for the last
assigned value. (Uncommitted snapshot transaction, the table has a field
which is a singular primary key, the field has a 'before insert' trigger
associated with it that is also associated with a generator, and the
most recent operation was an INSERT and it didn't affect more than one
record)
If anyone is interested, I'll be adding this to PHP5 as soon as its
first release is final. This would mean the function can be available in
PHP 5.1
Comments anyone?
--
Ard