How to update each table in a joined SELECT statement?

[smartkid]

I have a TOracleDataSet, which SQL property is set as the following:

SELECT a.rowid, a.aid, a.col_1, b.bid, b.rowid, b.col_2
FROM a, b WHERE a.aid = b.bid;

I checked the UpdateTable property of TOracleDataSet but do think only one table can be updated at a time.

------------------

 

[Marco Kalter]

The TOracleDataSet can indeed only update one table. If you want to update multiple tables through one dataset, you need to use the OnApplyRecord event. This event allows you to use any number of SQL statements to lock, insert, update, delete or fetch a single dataset record.

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