ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Communication / Salesforce functions
  • Properties specific to sfExecuteQueryResult variables
  • Functions that handle the sfExecuteQueryResult type
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
sfExecuteQueryResult (Type of variable)
In french: sfRésultatExécuteRequête
The sfSaveResult type is used to find out the result of SFForwardQuery and SFExecuteQuery. The characteristics of this result are returned by several WLanguage properties.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Example
// Connect to Salesforce
Cnt is sfConnection
Cnt.Login = "balthazar@gmail.com"
Cnt.Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END
 
// Retrieve the data
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
Remarks

Properties specific to sfExecuteQueryResult variables

The following properties can be used to handle the result of SFForwardQuery and SFExecuteQuery:
NameType usedEffect
DoneBoolean
  • True if the query was entirely run,
  • False otherwise.
This property is useful when running SFForwardQuery.
This property is read-only.
QueryLocatorCharacter stringQuery location. This property is useful when running SFForwardQuery.
This property is read-only.
ObjectArray of sfObjectSalesforce records corresponding to the result of the query.
SizeIntegerNumber of records corresponding to the result.
This property is read-only.

Functions that handle the sfExecuteQueryResult type

SFExecuteQueryRuns an SOQL query (Salesforce Object Query Language) on a Salesforce database.
SFForwardQueryContinues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/26/2023

Send a report | Local help