Use a trigger on insert. In the trigger program you can get the identity
column and do what you need to do from there.
Andeco Software, LLC
932 Saint Johns Dr
Maryville, TN 37801
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: Thursday, June 16, 2011 2:31 PM
Subject: SQL - Identity column.
Is there a way, when I write a record with a identity column, that the
SQL can return the value?
I would like to push that value to other files, but am I stuck to
retrieving the record again to find out the value of the identity column?
This mailing list archive is Copyright 1997-2019 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