|
|
|
|
|
|
|
|
|
|
- Properties specific to sfExecuteQueryResult variables
- Functions that handle the sfExecuteQueryResult type
sfExecuteQueryResult (Type of variable) In french: sfRésultatExécuteRequête
The sfSaveResult type is used to find out the result of SFForwardQuery and SFExecuteQuery. The characteristics of this result are returned by several WLanguage properties. Remark: 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 = "balthazar@gmail.com"
Cnt.Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END
Â
// Retrieve the data
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 sfExecuteQueryResult variables | | | | Name | Type used | Effect |
|---|
| Done | Boolean | - True if the query was entirely run,
- False otherwise.
This property is useful when running SFForwardQuery.
This property is read-only. | | QueryLocator | Character string | Query location. This property is useful when running SFForwardQuery.
This property is read-only. | | Object | Array of sfObject | Salesforce records corresponding to the result of the query. | | Size | Integer | Number of records corresponding to the result.
This property is read-only. |
Functions that handle the sfExecuteQueryResult type | | | SFExecuteQuery | Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database. | | SFForwardQuery | Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|