SFDelete (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Possible error cases:

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SFDelete (Function)

In french: SFSupprime

Deletes records from a Salesforce database.

Versions 20 and later

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

New in version 20

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

Versions 24 and later

This function is now available for WEBDEV sites in Linux.

New in version 24

This function is now available for WEBDEV sites in Linux.

Example

// 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.

Component : wd240ggl.dll