Print Thread
Foreign key field automaticlly become read-only.
#3679 07/10/02 02:52 PM
Joined: May 2001
Posts: 14
Taiwan
D
Member
OP Offline
Member
D
Joined: May 2001
Posts: 14
Taiwan
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?

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

Re: Foreign key field automaticlly become read-only.
#3680 07/10/02 05:58 PM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
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


Marco Kalter
Allround Automations
Re: Foreign key field automaticlly become read-only.
#3681 07/10/02 08:13 PM
Joined: May 2001
Posts: 14
Taiwan
D
Member
OP Offline
Member
D
Joined: May 2001
Posts: 14
Taiwan
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?


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

Re: Foreign key field automaticlly become read-only.
#3682 07/11/02 09:04 PM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
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


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.040s Queries: 13 (0.008s) Memory: 2.5056 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-21 01:32:47 UTC
Valid HTML 5 and Valid CSS