I like to update two database tables, which are joined together in a view. The TOracleDataSet looks on this view, using a select statement.
Now I need a simple solution for insert, update and delete records in the underlaying tables.
You have two options:
1. create an updatable view in oracle using instead-of triggers.
2. write the code to handle the inserts/updates/deletes in delphi using the OnApplyRecord event of the TOracleDataset.
[This message has been edited by jpickup (edited 22 February 2002).]
