Re: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-22 Thread BEVERLY VOTH
om > land: 215-799-0192 > > > From: "Robert Shubert" > Sent: Monday, October 21, 2013 10:19 PM > To: TeraScript-Talk@terascript.com > Subject: RE: TeraScript-Talk: ACTIONRESULTS for Insert > > I think it supports transactions, if it does you should be able to do: >

RE: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-22 Thread d...@dss-db.com
cript-Talk@terascript.com Subject: RE: TeraScript-Talk: ACTIONRESULTS for Insert I think it supports transactions, if it does you should be able to do: Open transaction Insert new record into table Select MAX(ID) from table Close transaction Robert From: Wayne Irvine [mailto:wa...@bytese

RE: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-21 Thread Robert Shubert
@terascript.com Subject: Re: TeraScript-Talk: ACTIONRESULTS for Insert Thanks Beverly, that's the method I have always used previously. Guess it's still the way to do it in my case. Wayne On 22/10/2013, at 6:24 AM, Beverly Voth mailto:beverlyv...@gmail.com> > wrote: FileMake

Re: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-21 Thread Wayne Irvine
ELECT @@IDENTITY” immediately after an INSERT and it returns the >> auto-increment primary key of the record just inserted. >> >> Robert >> >> From: Wayne Irvine [mailto:wa...@byteserve.com.au] >> Sent: Monday, October 21, 2013 12:32 AM >> To: TeraS

Re: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-21 Thread Beverly Voth
gt; To: TeraScript-Talk@terascript.com > Subject: TeraScript-Talk: ACTIONRESULTS for Insert > > I am using Terascript talking JDBC to FileMaker Pro Server. > > I'm doing an Insert action and would like to retrieve the ROWID of the new > record > > Action:InsertReco

RE: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-21 Thread Robert Shubert
. Robert From: Wayne Irvine [mailto:wa...@byteserve.com.au] Sent: Monday, October 21, 2013 12:32 AM To: TeraScript-Talk@terascript.com Subject: TeraScript-Talk: ACTIONRESULTS for Insert I am using Terascript talking JDBC to FileMaker Pro Server. I'm doing an Insert action and would li

Re: TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-20 Thread Bishop Weiss
Not sure about FileMaker. But found this in MySQL http://viralpatel.net/blogs/get-autoincrement-value-after-insert-query-in-mysql/ Sent from my iPad > On Oct 20, 2013, at 10:31 PM, Wayne Irvine wrote: > > I am using Terascript talking JDBC to FileMaker Pro Server. > > I'm doing an Insert action

TeraScript-Talk: ACTIONRESULTS for Insert

2013-10-20 Thread Wayne Irvine
I am using Terascript talking JDBC to FileMaker Pro Server. I'm doing an Insert action and would like to retrieve the ROWID of the new record Action:InsertRecord Results Action: <@ACTIONRESULT NAME="InsertRecord" NUM="1"> It is returning nothing. Wayne Irvine w: http://www.byteserve.com.au/ p