You can also use a Direct DBMS containing: select <@literal @@identity>
immediately after the insert action. This will result in one record being returned which will be the id of the record you have just inserted (<@ASSIGN request$Record_ID "@@request$ResultSet[1,1]">) You will need to have both the insert action and the Direct DBMS within a Begin/End Transaction for this to work. ----- Original Message ----- From: "Wayne Irvine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 8:25 AM Subject: Re: Witango-Talk: getting the record number of the row justcreated > > Another case of brain freeze.... > > > > I create a new record. The database auto-increments the unique id field. > > How do I get that field value for the next action of my application? > > It's in the resultSet. Just refer to resultSet[1,1] or assign the result set > to a Var and use it anywhere in your app. > > Wayne Irvine > Byte Services Pty Ltd > http://www.byteserve.com.au/ > [EMAIL PROTECTED] > Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
