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.