OracleDataSet

[robert_farquhar]

I have an oracledataset linked to a grid.
The query returns 2 fields, the first is a code from the main table and the second is a description from a lookup table (using the code field). For browsing things are fine. My problem is when editing the code field, if the value changes I want a refresh the lookup description value. If I programatically allocate the description field the SQL update statement includes the description field, even though it is in a secondary lookup table. This results in an error saying that description does not exist. What is the work around to this

 

[Marco Kalter]

You should set the FieldKind property of the lookup field to fkInternalCalc, because the column is not part of the updating table. Note that you can set ToracleDataSet.RefreshOptions to [roAfterInsert, roAfterUpdate, roAllFields] to automatically refresh lookup fields after a record is created or updated.

------------------
Marco Kalter
Allround Automations