Hi all.
How can I insert a new row in a dataset when it is formed by multiple tables connected with a JOIN statement?
For example I have this SQL
SELECT t1.rowid, t1.name, t1.address, t1.age, t2.role FROM t1, t2 WHERE t1.id = t2.id
I want to be able to insert a new row
in table t1 via a data aware grid (devexpress cxgrid to be precise).
However, even if I fill out the
UpdatingTable property, the INSERT operation fails because the dataset tries to include columns from table t2.
Is there any way to accomplish this?