Jump to content

Search the Community

Showing results for tags 'delete multiple'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 1 result

  1. 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?
×
×
  • Create New...