Re: TeraScript-Talk: Insert action results

2018-07-20 Thread Wayne Irvine
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 wrote: > > If I understand...Years ago I was taught this technique which I am sure you > know already. > > Prior to an insert create a uniqu

Re: TeraScript-Talk: Insert action results

2018-07-20 Thread D Mark Weiss
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.

RE: TeraScript-Talk: Insert action results

2018-07-20 Thread Robert Shubert
Ok, so we are getting back the fact that the insert occurred. Usually this is done with a connection query. In SQL Server it's: SELECT @@identity One way you can do it is to immediately SELECT max(id) FROM table - assuming that the key you want is auto incrementing. Doing this in a transaction

Re: TeraScript-Talk: maxlength="0"

2018-07-20 Thread Wayne Irvine
Type is text: Wayne > On 21 Jul 2018, at 1:53 am, Robert Shubert wrote: > > Is this a FM data source? If so, what’s the data type of that column in > FileMaker? > > From: Wayne Irvine [mailto:wa...@byteserve.com.au > ] > Sent: Thursday, July 19, 2018 5:56 PM > T

Re: TeraScript-Talk: Insert action results

2018-07-20 Thread Wayne Irvine
<@NUMAFFECTED> returns 1 > On 21 Jul 2018, at 1:52 am, Robert Shubert 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

RE: TeraScript-Talk: maxlength="0"

2018-07-20 Thread Robert Shubert
Is this a FM data source? If so, what’s the data type of that column in FileMaker? From: Wayne Irvine [mailto:wa...@byteserve.com.au] Sent: Thursday, July 19, 2018 5:56 PM To: TeraScript-Talk@terascript.com Subject: Re: TeraScript-Talk: maxlength="0" Size: 0 Wayne On 20 Jul 2018, a

RE: TeraScript-Talk: Insert action results

2018-07-20 Thread Robert Shubert
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 [ma