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: Open
transaction Insert new record into table Select MAX(ID) from table Close
transaction Robert From: Wayne Irvine [mailto:wa
: Robert Shubert rshub...@tronics.com
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:
Open transaction
Insert new record into table
Select MAX(ID
@ACTIONRESULT is deprecated
Usually you need to execute a second query to get the ID.
I don’t know how to do that in FMP, but, for example, in SQL Server you execute
“SELECT @@IDENTITY” immediately after an INSERT and it returns the
auto-increment primary key of the record just inserted.
FileMaker doesn't return IDENTITY like SQL/MySQL. I used to make sure I set a
field with a value that I could find again just after insert. SELECT the
record, get the recid, and probably clear that field with an UPDATE to the
record. It's been a few years, but this method should work whether
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 beverlyv...@gmail.com wrote:
FileMaker doesn't return IDENTITY like SQL/MySQL. I used to make sure I set a
field with a value that I
@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 beverlyv...@gmail.com
mailto:beverlyv...@gmail.com wrote
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 wa...@byteserve.com.au wrote:
I am using Terascript talking JDBC to FileMaker Pro Server.
I'm