@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 <mailto: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.