Hi Brian,
What about retrieving the Indentity in your instead of trigger and then
write it into a (SQL) Global Variable.
Within your program you then can access the global variable and get the
Indentity value.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Brian
Garland via MIDRANGE-L
Sent: Mittwoch, 4. März 2020 20:58
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Brian Garland <Brian.Garland@xxxxxxxxxx>
Subject: Getting the identity of an inserted row
I am doing an insert through a view that has an instead of trigger that
updates the table. The view has a join so that is the reason for the
instead of trigger.
The problem I have now is finding the identity of the new row after the
insert into the view.
The usual methods (identity_val_local or select identity from final table)
do not work in this scenario.
What can I do to get this identity?
--
Brian J. Garland
Vermont Information Processing, Inc.
brian.garland@xxxxxxxxxx
--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or company to whom they are addressed.
Do not disclose, distribute, or copy this email to others outside your
company. If you have received this email in error, please notify the sender
immediately and delete this email from your system.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
