Server (in database) derived values

matthieu de graaf · Post by **matthieu de graaf** » Wed 14 May 2008 12:24

Hi,

I want to derive the values of a number of columns in the database, by means of a database trigger; e.g. my primary key will be filled by the value of an oracle sequence.
Is there a way to convey these values back to the dataset without refreshing the contents of the dataset explicitely?
Theoretically oradirect can do this by taking advantage of the returning clause of the insert or update statement.

Regards,

Matthieu

Alexey.mdr · Post by **Alexey.mdr** » Wed 14 May 2008 12:59

Yes, it can be done.
Please see the following topics in OraDirect .NET documentation:
- OracleDataTable.RefreshingFields;
- OracleDataTable.RefreshMode;
- OracleCommandBuilder.RefreshingFields;
- OracleCommandBuilder.RefreshMode;