PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Properties specific to the description of sfObject variables
  • Functions that handle the sfObject type
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
sfObject (Type of variable)
In French: sfObjet (Type de variable)
The sfObject type is used to describe a record of a SalesForce file. The characteristics of this type of variable can be defined and modified by several WLanguage properties.
This type of variable is used by the following types of variables:
Note: See Declaring a variable for more details.
Versions 20 and later
WINDEVLinux This type of variable is now available for the WINDEV applications in Linux.
iPhone/iPad This type of variable is now available for the iPhone/iPad applications.
New in version 20
WINDEVLinux This type of variable is now available for the WINDEV applications in Linux.
iPhone/iPad This type of variable is now available for the iPhone/iPad applications.
WINDEVLinux This type of variable is now available for the WINDEV applications in Linux.
iPhone/iPad This type of variable is now available for the iPhone/iPad applications.
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

ResQuery is sfExecuteQueryResult
ResQuery = SFExecuteQuery(Cnt, "SELECT Date__c,Miles_c,Contact__c FROM Mileage__c")

ARecord is sfObject
FOR EACH ARecord OF ResQuery..Object
 Trace("---- Type: " + ARecord..ObjectType +" | ID: " + ARecord..ID)
 Trace(ARecord..Date__c + " / " + ARecord..Miles__c + " / " + ...
ARecord..Contact__c)
END
Remarks

Properties specific to the description of sfObject variables

The following properties can be used to handle a record of a Salesforce file:
NameType usedEffect
IDCharacter stringIdentifier of the record.
NullItemCharacter stringList of record items with no value. The different items are separated by CR characters (Carriage Return).
ObjectTypeCharacter stringName of the file to which the record belongs. This name must correspond to the name defined in the Salesforce interface as the "API name".
For a custom file, this name corresponds to the name of the file followed by 2 underscore characters then by the letter "c". For example: "MyAccount__c".
<Item Name>Type of itemAllows you to access any file item directly via its name.
Note: The name of the item must correspond to the name defined in the Salesforce interface as the "API name". For a custom file, this name corresponds to the name of the item followed by 2 underscore characters then by the letter "c". For example: "OpenDate__c".
Note: These properties can be used with one of the following syntaxes:
  • <Variable Name>..<Property Name>
  • <Variable Name>.<Property Name>

Functions that handle the sfObject type

Versions 14 and later
SFAdd
New in version 14
SFAdd
SFAdd
Creates a record in a file of a Salesforce database.
Versions 14 and later
SFModify
New in version 14
SFModify
SFModify
Modifies the records of a file defined in Salesforce.
Versions 14 and later
SFRead
New in version 14
SFRead
SFRead
Retrieves the Salesforce records from their identifiers.
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment