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 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 you use > ODBC or XML. > > -- sent from my iPhone4 -- > Beverly Voth > -- > > On Oct 21, 2013, at 12:39 PM, "Robert Shubert" <rshub...@tronics.com> wrote: > >> @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. >> >> 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 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: +61 2 9960 6099 >> m: 0409 960 609 >> >> >> 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. > > To unsubscribe from this list, please send an email to > lists...@terascript.com with "unsubscribe terascript-talk" in the body. Wayne Irvine w: http://www.byteserve.com.au/ p: +61 2 9960 6099 m: 0409 960 609 ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.