Edit Joined Select Statement

[Jens Fudickar]

Is it possible to edit the fields of the "mail_group_address" table, using the following select-statement:

select mail_address.*,
mail_group_address.*, mail_group_address.rowid
from mail_address, mail_group_address
where mail_group_address.mga_ma_id = mail_address.ma_id

 

[Lauritz]

It sounds like the same problem as in: http://www.allroundautomations.nl/ubb/Forum1/HTML/000038.html ?

 

[Marco Kalter]

If you want to update both the mail_address and mail_group_address tables, then you indeed need to use the OnApplyRecord event to handle this.

If only the mail_group_address table needs to be updated, then this is possible. It needs to be the first table in the FROM clause, or you need to set the UpdatingTable property of the TOracleDataSet accordingly.

Note that this only makes sense if each mail_group_address record can only occur once in the dataset. If a record can occur more than once, the dataset can no longer identify the correct record (nor can the user).

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