PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Possible error cases:
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
SFAdd (Function)
In French: SFAjoute
Creates a record in a file of a Salesforce database. This file can be a preset file or a custom file.
Note: A "Salesforce record" is also called a "Salesforce object".
Versions 20 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 20
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Connection 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

// Define the records
MyRecords is array of sfObjects
ARecord is sfObject
ARecord..ObjectType = "Mileage__c"
ARecord..Date__c = "2009-02-14"
ARecord..Miles__c = 333
Add(MyRecords, ARecord)

ARecord..Date__c = "2009-02-15"
ARecord..Miles__c = 222
Add(MyRecords, ARecord)

// Add the records
arrRes is array of sfSaveResult
arrRes = SFAdd(Cnt, MyRecords)

// Read the result
res is sfSaveResult
err is sfError
FOR EACH res OF arrRes
Trace("---------- " + res..ID + ": " + res..Success + " ----------")
FOR EACH err OF res..Error
Trace("Error: " + err..ErrorCode + " -> " + err..Message + "(" + err..Item + ")")
END
END
Syntax
<Result> = SFAdd(<Salesforce Connection> , <Records to Create>)
<Result>: Array variable
Array of sfSaveResult variables containing the result data, especially the identifiers of records actually created.
<Salesforce Connection>: sfConnection variable
Name of sfConnection variable to use
<Records to Create>: Array variable
Array of sfObject variables corresponding to the records (Salesforce objects) to create.
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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230ggl.dll
Windows Mobile wp230ggl.dll
Linux wd230ggl.so
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment