Server (in database) derived values

Server (in database) derived values

Postby matthieu de graaf » Wed 14 May 2008 12:24


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.


matthieu de graaf
Posts: 18
Joined: Wed 14 May 2008 12:13

Postby 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;
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Return to dotConnect for Oracle