Subject | Master-Detail and ClientDataSets |
---|---|
Author | Salim Naufal |
Post date | 2003-06-10T15:00:03Z |
I am having severe problems with IBO and ClientDataSets. Besides misreported
precision and size, I am unable to get it running with master-details and
ClientDataSets. The structure is as follows:
Table
1 - SALE_HDR (CODE integer not null primary key, .....)
2 - SALE_DETAILS (CODE integer not null primary key, SALE_HDR_CODE INTEGER
NOT NULL references SALE_HDR(CODE) ....
When I try to apply the changes, I get the "No corresponding master record
found"
I have been using IBX without any problems in both cases.
Does anyone have any experience with the TIBOQuery, master-details and
ClientDataSets? Are there other alternatives? Please not that the SALE_HDR
table has about 1,000,000 records and SALE_DETAILS about 20,000,000 records.
I have an example to illustrate this problem. It includes a database with
just what is required.
Salim
precision and size, I am unable to get it running with master-details and
ClientDataSets. The structure is as follows:
Table
1 - SALE_HDR (CODE integer not null primary key, .....)
2 - SALE_DETAILS (CODE integer not null primary key, SALE_HDR_CODE INTEGER
NOT NULL references SALE_HDR(CODE) ....
When I try to apply the changes, I get the "No corresponding master record
found"
I have been using IBX without any problems in both cases.
Does anyone have any experience with the TIBOQuery, master-details and
ClientDataSets? Are there other alternatives? Please not that the SALE_HDR
table has about 1,000,000 records and SALE_DETAILS about 20,000,000 records.
I have an example to illustrate this problem. It includes a database with
just what is required.
Salim