StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Cascading Deletes and Updates

Cascading Deletes and Updates

Alex Luyando — Thu, 11 Aug 2011 16:41:41 GMT

Hi all.

Sorry, it's been a while since I've StrataFramed, so a bit rusty. Does SF support cascaded DELETEs/UPDATEs in parent-child relationships on maintenance forms without use of the DDT? If so, how is that controlled (i.e., how does one turn cascading on/off)?

TIA

RE: Cascading Deletes and Updates

Edhy Rijo — Thu, 11 Aug 2011 16:41:41 GMT

[quote][b]Alex Luyando (8/11/2011)[/b][hr]I see that the DDT allows for relating tables... does that actually persist the relationship back to the database or is the relationship kept at the "StrataFrame application" level? [/quote]
Hi Alex,

I understand, but anything you do in the DDT will basically persist in the database, not the SF Business Object, so if you don't have access to modify the database, then you will have to handle the cascade delete on your own. There are many ways to do this based on the level of validation you may need to do before deleting, but if no validation is required, instead of looping each child record, create a SQL command to delete all record for a particular FK value and use the BO.ExecuteScalar() to get the number of records deleted and then delete the parent record.

RE: Cascading Deletes and Updates

Alex Luyando — Thu, 11 Aug 2011 16:18:12 GMT

Hi Edhy.

Thanks... sorry... I didn't put the qualification in my posting that the database cannot be altered so that's not an option. I see that the DDT allows for relating tables... does that actually persist the relationship back to the database or is the relationship kept at the "StrataFrame application" level?

RE: Cascading Deletes and Updates

Edhy Rijo — Thu, 04 Aug 2011 18:36:28 GMT

Hi Alex,

Simply create a relationship in the database and set the RI cascade option there.