Foreign key field automaticlly become read-only.

[donychao]

When I use TOracleDataSet in a master-detail
relationship form,the master table
key field automaticlly become read-only.
But sometimes I really have to change it.
How should solve this problem?

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

 

[Marco Kalter]

The primary key column changes of the parent table cannot be cascaded by the TOracleDataSet to the foreign key columns of the child record(s). Therefore these master fields are read-only if detail records exist.

If you want to change the master fields, you will have to apply your own master/detail synchronization instead of using the built-in master/detail functionality.

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

 

[donychao]

You said:
-----------------------------------
The primary key column changes of the parent table cannot be cascaded by the TOracleDataSet to the foreign key columns of the child record(s). Therefore these master fields are read-only if detail records exist.
-------------------------------------
This is not the case. when I get no
records in the detail,
the primary key field of the parent still
cant be changed at all. Why?

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

 

[Marco Kalter]

I'm not sure why. This is how it should work, and how it works (for example) in the DeptEmp demo project...

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