Re: Getting the identity of an inserted row

Hi Brian,
you can use the "FINAL TABLE" ... something like:

// Get the ID the new record my MYTABLE
exec sql
select id into :LastID from final table (
insert into MYTABLE
(FIELD1, FIELD2))
values(:VAL1, :VAL2)
);

HTH
Roberto


Il giorno mer 4 mar 2020 alle ore 20:58 Brian Garland via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> ha scritto:

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