Devart Forums

Hi, as a continuation of this topic viewtopic.php?t=27242

i tried to implement a sample in which master detail relationship is done with MasteSource.

when i delete a master record anyway i do not see that the deletion of the details is done correctly.

i will send the sample to support.

i hope you can reply since i am stuck.

THanks.

When creating the "FK_Detailtbl_Mastertbl" foreign key constraint, add the DELETE CASCADE option. Cascade deletion will help retain the link integrity of your database.
For example, here's a foreign key constraint creation script:

Thanks for the reply.
So you mean that there is no way to obtain deletiong thgouh "cached updates" withotu using the cascade delete option?

I thought that teh dataset could handle this.

Thanks.

The logic in your sample differs from the logic in the sample described in the viewtopic.php?t=27242 topic. When you delete records from the master dataset. you have to manually delete records from the detail dataset as well. SDAC doesn't automatically delete records from the detail dataset.