Join update

[valtasar]

Hi all!

Is it possible update join by two table without additional coding? I mean something like ADO master table feature, that describes wich table should be updated in multytable select.

I have to update simle select where ine of the fields is just lookup performed on server. I use CashedUpdates and select rowid for main table. But when I tryed to apply updates I got ORA-01410 error. Invalid ROWID.
I guess it should be doible without using OnApplyRecord.

WBR

 

[Marco Kalter]

By default the TOracleDataSet will use the first table in the table list of the select statement. If you want to update another table, you can either change the SQL statement and list that table first, or you can set the UpdatingTable property.

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