If I understand...Years ago I was taught this technique which I am sure you know already.
Prior to an insert create a unique variable. When you make the insert save that variable into a column for that record Then select row ID or unique ID for that row using that same variable on that column. I suppose it’s not elegant. But it really doesn’t create that much overhead I don’t think Mark D Mark Weiss CM Harbor, LLC PonyTracker 435-363-6363 > On Jul 20, 2018, at 10:16 AM, Wayne Irvine <[email protected]> wrote: > > <@NUMAFFECTED> returns 1 >> On 21 Jul 2018, at 1:52 am, Robert Shubert <[email protected]> wrote: >> >> It may now. Check @NUMAFFECTED afterwards. >> >> This is something we're looking at supporting better in v8 with an explicit >> flag to obtain the identity after insert. JDBC supports a mechanism for >> doing so, but we need to explicitly invoke it. >> >> Robert >> >> -----Original Message----- >> From: Wayne Irvine [mailto:[email protected]] >> Sent: Thursday, July 19, 2018 7:56 PM >> To: [email protected] >> Subject: Re: TeraScript-Talk: Insert action results >> >> Scratch that. Seems I asked the same question 5 years ago. The answer in the >> case of FMS as a JDBC datasource is no. >> >>> On 20 Jul 2018, at 12:48 pm, Wayne Irvine <[email protected]> wrote: >>> >>> The Search action returns @@resultset. Does the Insert action return any >>> results (a row ID for example) and if so how do we access it? >>> >>> Wayne >>> >>> Byteserve Pty Ltd >>> w: http://www.byteserve.com.au/ >>> e: [email protected] >>> p: +61 02 9960 6099 >>> m: 0409 960 609 >>> f: +61 02 9960 6088 >>> >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to >>> [email protected] with "unsubscribe terascript-talk" in the body. >>> >> >> Byteserve Pty Ltd >> w: http://www.byteserve.com.au/ >> e: [email protected] >> p: +61 02 9960 6099 >> m: 0409 960 609 >> f: +61 02 9960 6088 >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> > > Byteserve Pty Ltd > w: http://www.byteserve.com.au/ > e: [email protected] > p: +61 02 9960 6099 > m: 0409 960 609 > f: +61 02 9960 6088 > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
