I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot
get
the UpdateRowSource.FirstReturnedRecord of the InsertCommand to work
correctly using the System.Data.OracleClient. It works correctly on 1.1
and
the DataSet is updated correctly after a DataAdapter.Update, but although
the
insert happens to the database on 2.0, the DataSet is not updated.
My InsertCommand is a stored procedure that gets the next id (primary key)
for the tables instance, inserts the new record with the id, and then gets
the newly inserted row as an output.
The expected behaviour is the DataSet I passed into the Update method as
an
output is returned with the record containing the new id.
Has anybody run into this problem and found a work-around?
Regards,
Albert
