|
|
|
|
|
SFForwardQuery (Function) In french: SFAvanceRequête Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database. The query was run by SFExecuteQuery.
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")
LOOP
MonEnregistrement is sfObject
FOR EACH MonEnregistrement OF ResRequête.Object
Trace("---- Type : " + MonEnregistrement.ObjectType + " | ID : " + MonEnregistrement.ID)
Trace(MonEnregistrement..Date__c + " / " + ...
MonEnregistrement..Miles__c + " / " + MonEnregistrement..Contact__c)
END
IF ResRequête.Done = False THEN
ResRequête = SFForwardQuery(Cnx, ResRequête.QueryLocator)
ELSE
BREAK
END
END
FOR EACH MonEnregistrement OF ResRequête.Object
Trace("---- Type : " + MonEnregistrement.ObjectType + ...
" | ID : " + MonEnregistrement.ID)
Trace(MonEnregistrement..Date__c + " / " + ...
MonEnregistrement..Miles__c + " / " + MonEnregistrement..Contact__c)
END
Syntax
<Result> = SFForwardQuery(<Salesforce connection> , <Query location>)
<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 location>: Unicode string String used to identify the query. This string is returned by the QueryLocator property of the last sfExecuteQueryResult variable received. 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|