Hi,
those relationships are in the data, meaning that Product is inside CommercieelProduct. Stimulsoft Designer place these relationship. I cannot influence those relationships, or can i?
I have created a stripped down mrt file. So, for example Collo is not in the mrt file anymore.
However, I still have the same problem.
Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.
Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.
- Attachments
-
- 554.Order.mrt
- (30.51 KiB) Downloaded 200 times
Cannot add constraint to DataTable 'Product' which is a child table in two nested relations.
Hello,
When ADO reads XML into a DataSet, it creates DataTables to contain each type of element it encounters. Each table is uniquely identified by its name.
Also, a given table can have any number of parent tables, but only one of its parent relations can be nested - otherwise, a given record would get written to the XML multiple times, as a child of each of its parent rows.
In your report next relations:
Code -> Product (Code.Product_ID = Product.Product_ID) -> Code (Product.Product_ID = Code.Product_ID)
These relations and issue an error message.
Thank you.
When ADO reads XML into a DataSet, it creates DataTables to contain each type of element it encounters. Each table is uniquely identified by its name.
Also, a given table can have any number of parent tables, but only one of its parent relations can be nested - otherwise, a given record would get written to the XML multiple times, as a child of each of its parent rows.
In your report next relations:
Code -> Product (Code.Product_ID = Product.Product_ID) -> Code (Product.Product_ID = Code.Product_ID)
These relations and issue an error message.
Thank you.