Delete Multiple Records - Autosubmit

[LWSChad]

Hello All!

I am building a routine to delete a "Lead" that is organized into many normalized tables.

tblLead

-tblPerson

-tblPhone

-tblEmail

-tblAddress

-tblVehicle

-tblPolAuto

-tblPolHome

-tblNote

-tblActionLog

-tblLinkDupes

 

Each child table uses LeadID as a Foreign Key to relate to tblLead.  Using SQL deleting these records would be an easy feat... (and I may end up doing this every night after my scheduled task export backup, but that is far from optimal)

DELETE FROM tblPerson WHERE LeadID=x;
DELETE FROM tblPhone WHERE LeadID=x;
etc. 

In Caspio I cannot think of a fast way to do this.

 

My anticipated approach is to cycle through an auto-submitted and confimation disabled data page for every table, but what is going to happen when the child table has more than one record where LeadID=x.

 

Has anybody dealt with this?

[jonathanr]

Hi Chad,

 

Cascade Delete and Cascade Update features are in the works and they will allow you to accomplish the task you described.

 

Regards,
Jonathan

[LWSChad]

OK, cool.

In that case I'll wait until that is complete.

In the meantime I'll simply mark leads for deletion and do it either with SQL on my local machine or by directly manipulating the Caspio tables.

 

Thanks