Monday, October 24, 2005

Maser Detail

Newsgroups: borland.public.datasnap
From: "Dave Rowntree" - Find messages by this author
Date: Fri, 21 Dec 2001 19:26:47 -0000
Local: Sat, Dec 22 2001 3:26 am
Subject: Re: nested dataset fields

You can still process the deletes yourself in the DSP.BeforeUpdateRecord
event using the method I described. When you delete a record yourself set
Applied := True in your code, and MIDAS will ignore the delete request.

Another way is to set poCascadeDeletes := True, and do nothing in your
client app. Just let the user delete the master records. Bear in mind that
the *only* deletes you will be notified of in the DSP.BeforeUpdateRecord
will be the master record deletes. You are then responsible for carrying out
*all* the necessary processing in respect of detail records, at all levels,
for that master. How you process the detail records is up to you. It mainly
depends on how much of the processing you want to occour on the database,
and how much in Delphi. You could use database triggers, construct update
queries, use select queries to pull info into Delphi to handle the maths in
Delphi instead of in the database, etc, etc. It depends what you are wanting
to achieve.


Post a Comment

<< Home