CachedUpdates and CommitOnPost

[DAVIDSS]

I have many problems with this, my form is master/detail, with CachedUpdates = True and CommitOnPost = False, when ApplyUpdates is called an oracle error raise: "parent key not found", some times is the master and some times is the detail because this error is not frequent, and the data in the foreign key fields is ok... why is this possible???

 

[Marco Kalter]

How exactly do you apply the updates? Can you send me the code?

 

[DAVIDSS]

OdsLicencia (Master) [Problems]
OdsDetalleLicencia (Detail) [Problems]
OdsDetalleOrden (Detail/Detail) [Ok]

//after all changes in tables(insert, delete, edit)

LE_Session.ApplyUpdates([OdsLicencia, OdsDetalleLicencia, OdsDetalleOrden], False);

LE_Session.CommitUpdates([OdsLicencia, OdsDetalleLicencia, OdsDetalleOrden]);

 

[Marco Kalter]

I'm not sure I understand. How can the master dataset raise a "parent key not found" error? It is after all the parent...

 

[DAVIDSS]

the master table also have foreign keys from another tables, that's why raise an parent key error, in the detail the key with problems not belong from the master, is from another table.

but the real problem is the applyupdates, the OracleDataSet have all the data in place, also I have tested with CachedUpdates = False, with commitonpost = True, and is Ok... that's why I'm worried... and the problem is not frequent..

 

[DAVIDSS]

my version of DOA it's too old... maybe it's a bug fixed, the version 4.0 will work fine in Delphi 6 professional??

 

[Marco Kalter]

Yes, it will work fine.

 

[DAVIDSS]

I've downloaded a new version, but I need to install in every client Delphi 6 to make this running...... there's no upgrades ?? I've my serial number and my product code, but the evaluation version don't have registration code... I've to purchase again DOA???????

 

[Marco Kalter]

The 3.4 --> 4.0 upgrade is covered by the Annual Service Contract. If you do not have a service contract, you can purchase one for USD 50 per license.

 

[DAVIDSS]

Ok... Thanks...