PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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
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
// Connect to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "qwerty" + "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 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 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.
Component : wd240ggl.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment