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.
