That’s exactly what I do at present. Before I insert I create a GUID, then after I search for that GUID.
Wayne > On 21 Jul 2018, at 2:51 am, D Mark Weiss <dadwe...@mac.com> wrote: > > 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 <wa...@byteserve.com.au> wrote: >> >> <@NUMAFFECTED> returns 1 >>> On 21 Jul 2018, at 1:52 am, Robert Shubert <rshub...@tronics.com> 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:wa...@byteserve.com.au] >>> Sent: Thursday, July 19, 2018 7:56 PM >>> To: TeraScript-Talk@terascript.com >>> 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 <wa...@byteserve.com.au> 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: i...@byteserve.com.au >>>> p: +61 02 9960 6099 >>>> m: 0409 960 609 >>>> f: +61 02 9960 6088 >>>> >>>> >>>> >>>> >>>> ---------------------------------------- >>>> >>>> To unsubscribe from this list, please send an email to >>>> lists...@terascript.com with "unsubscribe terascript-talk" in the body. >>>> >>> >>> Byteserve Pty Ltd >>> w: http://www.byteserve.com.au/ >>> e: i...@byteserve.com.au >>> p: +61 02 9960 6099 >>> m: 0409 960 609 >>> f: +61 02 9960 6088 >>> >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to >>> lists...@terascript.com with "unsubscribe terascript-talk" in the body. >>> >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to >>> lists...@terascript.com with "unsubscribe terascript-talk" in the body. >>> >> >> Byteserve Pty Ltd >> w: http://www.byteserve.com.au/ >> e: i...@byteserve.com.au >> p: +61 02 9960 6099 >> m: 0409 960 609 >> f: +61 02 9960 6088 >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> lists...@terascript.com with "unsubscribe terascript-talk" in the body. >> > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > lists...@terascript.com with "unsubscribe terascript-talk" in the body. > Byteserve Pty Ltd w: http://www.byteserve.com.au/ e: i...@byteserve.com.au p: +61 02 9960 6099 m: 0409 960 609 f: +61 02 9960 6088 ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.