SQL Yoga version 1.1.0 build 4 :: Visit website

Printer friendly version

command sqlrecord_delete

Deletes records in a database using the Record array(s) passed in.

command sqlrecord_delete @pRecordsA
Parameters
TypeNameDescription
Simple parameter. pRecordsA Records array/array of Record arrays (numerically indexed) that has the primary key column for each record filled in.
Description

This command deletes records from the database based on the Record array(s) passed in.

## Find lesson record in db with id of 12 and store in theRecordA 
sqlrecord_find "lessons", 12, theRecordA

sqlrecord_delete theRecordA
put the result into theError


Delete callbacks in your Table Object definitions will be called and broadcasts will be sent to listeners during this operation.

After this handler completes pRecordsA will only contain SQL Record(s) with the "@table" key. Other keys will have been removed since the data no longer exists in the database.

Return

Error message in 'the result', affected rows in 'it'