Subject | Getting the last inserted row ID |
---|---|
Author | Federico Tello Gentile |
Post date | 2004-09-30T02:52:29Z |
In the JayBird FAQ says that in order to get the last inserted row ID
when using a trigger to generate that ID with a generator it is
recommended to query first to generate the ID and then insert it
having the trigger not generate a new one when it is provided. I am
currently using a different approach, I'd like to know your opinions
about it.
What I do is:
select max(id) from table;
Is it much more inefficient? My app is a not inserting more than 10
rows at a time. It is an interactive application with only one user.
when using a trigger to generate that ID with a generator it is
recommended to query first to generate the ID and then insert it
having the trigger not generate a new one when it is provided. I am
currently using a different approach, I'd like to know your opinions
about it.
What I do is:
select max(id) from table;
Is it much more inefficient? My app is a not inserting more than 10
rows at a time. It is an interactive application with only one user.