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


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?

You can set TOracleDataSet.OracleDictionary.FieldKinds to True:

[quote]property FieldKinds: Boolean;
Automatically check which fields belong to the updating table. These fields will become data fields (FieldKind = fkData), and all other fields will become read-only InternalCalc fields (FieldKind = fkInternalCalc).[/quote]

Thank you, exactly what I needed.

The solution works however I realized it is not exactly what I want. Using the previous SQL as example:


Using the FieldKinds property allows me to post data to the right table but it also makes the column from t2 a read-only field! This means no value can be selected and I actually need that value further on.
Is there any way around this problem?

Thank you.

What exactly do you mean by "no value can be selected"?

The columns that do not belong to the UpdatingTable have become read only thus cannot be modified in the data-aware grid.
However I need to be able to select a value and pass it to the OnBeforePost() event for further manipulation

I haven't tried this, but what happens if you disable TField.ReadOnly for the fkInternalCalc field?