type is used to describe a record of a SalesForce file. The characteristics of this type of variable can be defined and changed using different WLanguage properties.
This type of variable is used by the following types of variables:
: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable
// Connect to Salesforce
Cnt is sfConnection
Cnt.Login = "email@example.com"
Cnt.Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
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 + " / " + ...
Properties specific to sfObject variables
The following properties can be used to handle a record of a Salesforce file:
|ID||Character string||Identifier of the record.|
|NullItem||Character string||List of record items with no value. The different items are separated by CR characters (Carriage Return).|
|ObjectType||Character string||Name 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 item||Allows you to access any file item directly via its name.|
Remark: 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".
Functions that handle the sfObject type
|SFAdd||Creates a record in a file of a Salesforce database.|
|SFModify||Modifies the records of a file defined in Salesforce.|
|SFRead||Retrieves the Salesforce records from their identifiers.|