I don't see it in the FM 12 ODBC/JDBC guide, Dan. Beverly
On 22 Oct 2013, at 6:46 AM, [email protected] wrote: > give it a try if you have FMP 12. I thought it was added. > > Sent from My Web Mail Account > Dan Stein MSN, CPNP, EMT-B > [email protected] > www.dss-db.com > land: 215-799-0192 > > > From: "Robert Shubert" <[email protected]> > Sent: Monday, October 21, 2013 10:19 PM > To: [email protected] > 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:[email protected]] > Sent: Monday, October 21, 2013 7:44 PM > To: [email protected] > 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 <[email protected]> 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" <[email protected]> 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:[email protected]] > Sent: Monday, October 21, 2013 12:32 AM > To: [email protected] > 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 > [email protected] with "unsubscribe terascript-talk" in the body. > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > > To unsubscribe from this list, please send an email to > [email protected] 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 > [email protected] with "unsubscribe terascript-talk" in the body. > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
