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 <[email protected]> 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 <[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. > 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.
