OTHER BIG BUG : deleting detail master delete

D2006+ADODataSet+SQLServer

In a master detail relation with transaction and batchoptimistic control,
happen that if i delete a detail record then in UpdateBatch also master
record is deleted from database table but not in a dataset !!!!

the help was :

Lookup the property "Unique Table" in the ado documentation.
(After opening your dataset, set
MyAdodataset.recordset.properties['Unique Table'].value:='MyDetailTable',
or alternatively: download and use tbetteradodataset instead of
tadodataset. It has a property "unique_table" that does the same.)

There is another simple way ?

Best regards GUIDO

--
Soluzioni Software di Gestione Aziendale
www.OnAzienda.it


.

Relevant Pages

  • Re: Deleting detail, master is deleted too !
    ... In a master detail relation with transaction and batchoptimistic control, happen that if i delete a detail record then in UpdateBatch also master record is deleted from database table but not in a dataset!!!! ...
    (borland.public.delphi.database.ado)
  • Deleting detail, master is deleted too !
    ... In a master detail relation with transaction and batchoptimistic control, ... happen that if i delete a detail record then in UpdateBatch also master ...
    (borland.public.delphi.database.ado)
  • deleting detail record
    ... In a master detail relation with transaction and batchoptimistic control, ... happen deleting master record does not delete detail records after ... updatebatch ... ...
    (borland.public.delphi.database.ado)
  • BIG BUG in Deleting detali records
    ... In a master detail relation with transaction and batchoptimistic control, ... happen deleting master record does not delete detail records after ... updatebatch ... ...
    (borland.public.delphi.database.ado)