How do you get the value for "RETURNING"

[Andrew Clow]

Hi Das,

The DAM will not fetch your 'returning value' until you tell it to.

If lReturnFlag
Do tstaobj.$fetchinto($cinst.cust_id)
End If

Your sequence will then be in the cust_id column of your row.

Regards,
Andrew


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Das Goravani
Sent: Wednesday, 31 January 2018 09:48
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Subject: How do you get the value for "RETURNING"

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
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com