I did read the whole message. I knew he was on 5.1.
I was commenting on your suggestion of a before insert trigger and the
downside of it. One being the lack of getting the value. Perhaps if I
had dropped the first part of the identity_val_local you might have made
it to the second part suggesting "select from insert" (which you snipped).
I was hoping that might be able to read a value inserted by a before
insert trigger. But I believe that support for "select from insert"
didn't come out until later also.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact