Get value from a new record

[crabgrass]

Suppose you use a command like oRS.addnew to add a new record to a data table, and suppose the table includes an autoinc field where the value is automatically established by the database, is there a way to query the value in this new record's autoinc field other than reissuing the select and oRS.movelast to get the new record?

Thanks

 

[johnwm]

Depends on what db you're using. If its MySQL then try

http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html

If its MSSQL then try

http://msdn2.microsoft.com/en-us/library/aa259185(sql.80).aspx

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints