SFModify (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Possible error cases

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SFModify (Function)

In french: SFModifie

Modifies the records of a file defined in Salesforce. This file can be a preset Salesforce file or a custom file.

Versions 20 and later

This function is now available for the WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

New in version 20

This function is now available for the WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

This function is now available for the WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

Versions 24 and later

This function is now available for the WEBDEV sites in Linux.

New in version 24

This function is now available for the WEBDEV sites in Linux.

Example

// Connect to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "azerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END

arrObjects is array of sfObject
ResQuery is sfExecuteQueryResult
sQueryText is string = "SELECT RecordTypeId, Recipient__c, "...
"ID, Subscript_of_mobiliot__c FROM BCM__c WHERE NAME='" + sSearch + "'"

ResQuery = SFExecuteQuery(Cnt, sQueryText)

ARecord is sfObject
FOR EACH ARecord OF ResQuery.Object
ARecord.Subscript_of_mobiliot__c = "698" // Modification
Add(arrObjects, ARecord)
END

arrRes is array of sfSaveResult
arrRes = SFModify(Cnt, arrObjects)
FOR EACH res OF arrRes
Trace("Success = "+res..Success)
END

Syntax

Modifying the existing records Hide the details

<Result> = SFModify(<Salesforce connection> , <Records to modify>)

<Result>: Array variable

Array of sfSaveResult variables that contains the result data, especially the identifiers of objects actually modified.

<Salesforce connection>: sfConnection variable

Name of sfConnection variable to use

<Records to modify>: Array variable

Array of sfObject variables corresponding to the Salesforce records to modify. This array can contain up to 200 elements.

Modifying the existing records or creating records Hide the details

<Result> = SFModify(<Salesforce connection> , <Records to modify or create> , <Mode> , <External identifier>)

<Result>: Array variable

Array of sfSaveResult variables that contains the result data, especially the identifiers of the objects actually modified.

<Salesforce connection>: sfConnection variable

Name of sfConnection variable to use

<Records to modify or create>: Array variable

Array of sfObject variables corresponding to the Salesforce records to modify or to create. This array can contain up to 200 elements.

<Mode>: Integer

Modification mode used:
sfCreationIfNotFound The record is automatically created if it does not exist.

<External identifier>: Character string

For a custom file, name of the item defined as unique item identifier from an external system.
This item is also used to identify the record to modify.
This item and its value are found in the sfObject object to modify.
The record will be automatically created if the value does not exist.
The record is updated if the value exists once.
An error is returned if the value exists several times.

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