Deletes records from a Salesforce database.
// Connect to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END
ResQuery is sfExecuteQueryResult
ResQuery = SFExecuteQuery(Cnt, "SELECT Date__c,Miles__c,Contact__c FROM Mileage__c")
MyRecord is sfObject
FOR EACH MyRecord OF ResQuery..Object
Trace("---- Type: " + MyRecord..ObjetType + " | ID: " + MyRecord..ID)
Trace(MyRecord..Date__c + " / " + MyRecord..Miles__c + ...
" / " + MyRecord..Contact__c)
END
//Delete an object
arrDel is array of strings
Add(arrDel, ResQuery..Object[1]..ID)
ResDel is array of sfDeleteResult
ResDel = SFDelete(Cnt, arrDel)
FOR EACH res OF ResDel
Trace("ID: " + res..ID + " - Deletion = " + res..Success)
END
Syntax
<Result> = SFDelete(<Salesforce connection> , <Records to delete>)
<Result>: Array variable
Array of sfDeleteResult variables containing the deleted data.
<Salesforce connection>: sfConnection variable
Name of sfConnection variable to use.
<Records to delete>: Array variable
Array of character strings containing the Salesforce identifiers of the records to delete.
Remarks
Possible error cases:
- The Internet connection is not valid.
- The authentication was not performed properly.
- The XML response of the server cannot be read.
To find out whether an error occurred, use the
ErrorOccurred variable.