PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
New WINDEV, WEBDEV, WINDEV Mobile 24 feature!
  • Possible error cases:
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
<sfConnection variable>.ForwardQuery (Function)
In french: <Variable sfConnexion>.AvanceRequête
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
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 20
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for iPhone/iPad applications.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 24 and later
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
New in version 24
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
Example
// Connect to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "qwerty" + "XXB12VCZ54"
IF Cnt.Connect =False THEN
Error("The connection failed")
RETURN
END

ResQuery is sfExecuteQueryResult
ResQuery = Cnt.ExecuteQuery("SELECT Date__c,Miles__c,Contact__c FROM Mileage__c")

LOOP
MyRecord is sfObject
FOR EACH MyRecord OF ResQuery..Object
Trace("---- Type: " + MyRecord..ObjetType + " | ID: " + MyRecord..ID)
Trace(MyRecord..Date__c + " / " + ...
MyRecord..Miles__c + " / " + MyRecord..Contact__c)
END
ResQuery = Cnt.ForwardQuery(ResQuery..QueryLocator)
DO WHILE NOT ResQuery..Done

FOR EACH MyRecord OF ResQuery..Object
Trace("---- Type: " + MyRecord..ObjetType + ...
" | ID: " + MyRecord..ID)
Trace(MyRecord..Date__c + " / " + ...
MyRecord..Miles__c + " / " + MyRecord..Contact__c)
END
Syntax
<Result> = <Salesforce connection>.ForwardQuery(<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 sfConnection variable to use
<Query location>: Unicode character string (with quotes)
String used to identify the query. This string is returned by ..QueryLocator 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.
Component : wd240ggl.dll
Minimum required version
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment