|
|
|
|
|
|
|
|
|
|
SFExecuteQuery (Function) In french: SFExécuteRequête Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.
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
Syntax
<Result> = SFExecuteQuery(<Salesforce connection> , <Query to run> [, <Deleted records>])
<Result>: sfExecuteQueryResult variable Name of the sfExecuteQueryResult variable that contains the result data, especially the Salesforce records corresponding to the query result. <Salesforce connection>: sfConnection variable Name of the variable of type sfConnection to be used. <Query to run>: Character string Code of query to run. This query is an SOQL query (Salesforce Object Query Language). For more details, see the Salesforce documentation. <Deleted records>: Optional boolean - True to include the deleted records in the query result,
- False (default) to include no deleted record in the query result.
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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|