Master/Detail with DOA

[Cervino]

I have an application client/server.
The structure is:
ApplicationServer ->
OracleDataSet (DOA 3.4.6.4) +
DataSetProvider

Client ->
ClientDataSet +
DataSource

In the case of Master/Detail there is :
-1 DOA Master
-1 DOA Detail
-1 DataSetProvider linked to DOA Master e with option EnablecascadeDelete and EnableCascedeupdate to true
-1 ClientDataSet for the master
-1 ClientDataSet for the detail linked to the DatasetField of Master.
When I execute an APPLYUPDATE the ID of the Master does't appear in sql of the Master DOA. The DBase return an error.
This situation don't appear if the Master ClientDataSet is empty.
I have to set a particular property in the DOA components?
The DOA are suitable for this structure??
I hope yes. How to do ??
Thank you

Marco Cervati

 

[Marco Kalter]

Have you set TDataSetProvider.ResolveToDataSet to False? This will be required in this situation.

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

 

[Cervino]

Yes, the DataSetProvider has the ResolveToDataset Property to False.

Marco Cervati

 

[fabiomaulo]

Yes, the ResolveToDataSet is set to false.
Rember that all work fine if the tables are empty. The first time you run the application u can append all records you want but in the second run of the application (without change any components properties) the ID of the master table is not included in the "insert" SQL.

Originally posted by mkalter:
Have you set TDataSetProvider.ResolveToDataSet to False? This will be required in this situation.