Inside a transaction,
I insert a row into the table, with an autonumber id.
Now I want to return the id of the newly inserted row. How can I do
that?
It seems that the first insert statement is not committed, and so the
second statement couldn't return the newly id.
I looked at the set transaction, but it doesn't seem to provide a way to
set transaction write committed.
Thanks,