Subject | RE: [firebird-php] auto increment last insert |
---|---|
Author | Alan McDonald |
Post date | 2004-11-24T07:34:28Z |
Hi
I believe that Firefox uses gen_id to trigger a generator to be used
for auto incrementing values. Mysql on PHP has an easy way
(mysql_insert_id) in determining the last inserted id. Do we have a
corresponding feature like this for firebird?
Thanks.
Arnold
[Alan McDonald] Firefox os the browser, Firebird is the RDBMS
This is how I get a new value
$newcontactid = $db->get_var("SELECT GEN_ID(GEN_CONTACT,1) FROM
RDB\$DATABASE");
Then you use it to insert your new record
Alan
[Non-text portions of this message have been removed]
I believe that Firefox uses gen_id to trigger a generator to be used
for auto incrementing values. Mysql on PHP has an easy way
(mysql_insert_id) in determining the last inserted id. Do we have a
corresponding feature like this for firebird?
Thanks.
Arnold
[Alan McDonald] Firefox os the browser, Firebird is the RDBMS
This is how I get a new value
$newcontactid = $db->get_var("SELECT GEN_ID(GEN_CONTACT,1) FROM
RDB\$DATABASE");
Then you use it to insert your new record
Alan
[Non-text portions of this message have been removed]