[egenix-users] how to insert new row, update in-memory object with same row from database?

[Michael Rothwell]

I'm trying to achieve the following:

* INSERT a blank record into a table.

* update a result set with that inserted row's data (which may have 
default values and identity fields filled in, now, by the database)

* edit the result set

* UPDATE the row with the new data


... the trick is selecting the newly inserted row. Does anyone know if 
there is a way to do this without resorting to a database- and 
table-specific method (such as using identity fields and slecting 
@@IDENTITY)?


-Michael