There may be an easier way. More elegant, but...
If there is a max rows function, do a search after the insert,
OR the more sure way is to create a uniquenumber using
<@timetosecs>, put it into a variable, then insert the var during
the insert and then do a search for rowid using the var after the
insert.
I have been doing this for years and it has been excellent. If you
have tons of concurrent things going on, you might want to add
something like <@userreferenceargument> or something to <@timetosec)
so that you are sure it is unique. make sure the field you are
inserting it into is large enough for all those chars.
Mark Weiss
On Mar 29, 2007, at 4:35 PM, Kent Swisher wrote:
I am converting from T2K Mac/Filemaker 4 to Witango 5.5 PC and FMSA
8 via ODBC. Hit a stumbling point.
Used to use <@ACTIONRESULT NAME=actionName NUM=1> to get the
record_id of the record that was just inserted.
This no longer works from PC using ODBC.
So, how do you get the ROWID of the just inserted record from FMSA
8 via ODBC on a PC? Via a direct DBMS action? Tried this using Get
(RecordID) but get a SQL parse error.
-> Kent Swisher Engineering Services
-> Alcatel-Lucent Application Support Engineer
-> Wireline Access Products [EMAIL PROTECTED]
-> Petaluma, CA 707-792-7116
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Mark Weiss
http://trustthechildren.blogspot.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
