|
|
|
|
|
|
|
|
|
|
- Properties specific to sfExecuteQueryResult variables
- Functions that use the sfExecuteQueryResult type
sfExecuteQueryResult (Variable type) 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. Note: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Cnx is sfConnection
Cnx.Login = "balthazar@gmail.com"
Cnx.Password = "azerty" + "XXB12VCZ54"
IF SFConnect(Cnx) = False THEN
Error("La connexion a échoué")
RETURN
END
ResRequête is sfExecuteQueryResult
ResRequête = SFExecuteQuery(Cnx, "SELECT Date__c, Miles__c, Contact__c FROM Mileage__c")
UnEnregistrement is sfObject
FOR EACH UnEnregistrement OF ResRequête.Subject
Trace("---- Type : " + UnEnregistrement.ObjectType + " | ID : " + UnEnregistrement.ID)
Trace(UnEnregistrement.Date__c + " / " + UnEnregistrement.Miles__c + " / " + ...
UnEnregistrement.Contact__c)
END
Properties 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. |
Remarks Functions that use 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|