ORACLE PL SQL help needed! using asp.net C# front end - trying to update and display two related columns
Posted on 2007-04-11
Using ORACLE 10G and asp.net C#
I have a table and a couple of views.
I have to columns that are of datatype number and these are populated from the user via my asp app
each column that is populated has an imediate effect on the other for example:
col_1 = (col_2 * rate)
and col_2 = (col_1 / rate)
It is displayed in a gridview and the user can input on either of the columns but will not input on both of them in the same row
How can I represent this on the database side so that which ever option the user decides to update it has an automatic result on the other column when they click the save button?
Any help on this would be great