PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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
SFExecuteQuery (Function)
In French: SFExécuteRequête
Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.
Versions 20 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the 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 the iPhone/iPad applications.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Connection to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "azerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END

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

ARecord is sfObject
FOR EACH ARecord OF ResQuery..Object
 Trace("---- Type: " + ARecord..ObjectType + " | ID: " + ARecord..ID)
 Trace(ARecord..Date__c + " / " + ARecord..Miles__c + " / " + ...
ARecord..Contact__c)
END
Syntax
<Result> = SFExecuteQuery(<Salesforce Connection> , <Query to Run> [, <Deleted Records>])
<Result>: sfExecuteQueryResult variable
Name of sfExecuteQueryResult variable containing the result data, especially the Salesforce records corresponding to the query result.
<Salesforce Connection>: sfConnection variable
Name of sfConnection variable to use.
<Query to Run>: Character string (with quotes)
Code of query to run. This query is an SOQL query (Salesforce Object Query Language). See the Salesforce documentation for more details.
<Deleted Records>: Optional boolean
  • True to include the deleted records in the query result,
  • False (default value) 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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230ggl.dll
Windows Mobile wp230ggl.dll
Linux wd230ggl.so
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment