How do you get the value for "RETURNING"

Das Goravani das at Goravani.com
Tue Jan 30 15:48:12 EST 2018


Friends, 

At the end of an INSERT INTO statement I have the clause ‘returning’ and my cust_id field name there.

How do you GET what is returned, or WHERE is it returned

I’ve examined the row to see if it put it in the fields place, no, I’ve fetched, can’t get it. 

This is in an effort to get back the unique sequence number just assigned so I can show it onscreen.

Another way to put this is “how do you get back a record just inserted”, how to select or fetch it back with it’s values including the sequence

I am successfully now assigning sequence numbers..that is working..but I cannot get the record back, I cannot get the seq no. just assigned

Regards

Das


More information about the omnisdev-en mailing list