PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Possible error cases:
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database. The query was run by SFExecuteQuery.
Versions 20 and later
Linux This function is now available for WINDEV applications in Linux.
New in version 20
Linux This function is now available for WINDEV applications in Linux.
Linux This function is now available for WINDEV applications in Linux.
Versions 24 and later
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
New in version 24
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Example
// Connexion à Salesforce
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..Subject
Trace("---- Type: " + MonEnregistrement..ObjectType + " | ID: " + MonEnregistrement..ID)
Trace(MonEnregistrement..Date__c + " / " + ...
MonEnregistrement..Miles__c + " / " + MonEnregistrement..Contact__c)
END
ResRequête = SFForwardQuery(Cnx, ResRequête.QueryLocator)
TO DO WHILE NOT ResRequête.Done
 
FOR EACH MonEnregistrement OF ResRequête..Subject
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 sfExecuteQueryResult variable that contains the result data, especially the Salesforce records corresponding to the query result.
<Salesforce connection>: sfConnection variable
Name of the Variable type sfConnection to be used.
<Query location>: Unicode string
String used to identify the query. This string is obtained thanks to the Property LocationRequest of the last received Variable sfExecuteQueryResult.
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.
Component: wd270ggl.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment