PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Properties specific to the description of 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
sfExecuteQueryResult (Type of variable)
In french: sfRésultatExécuteRequête (Type de variable)
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: See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties.
Versions 20 and later
Linux This type of variable is now available for WINDEV applications in Linux.
New in version 20
Linux This type of variable is now available for WINDEV applications in Linux.
Linux This type of variable is now available for WINDEV applications 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
 
// 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 the description of 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 available in read-only.
QueryLocatorCharacter stringQuery location. This property is useful when running SFForwardQuery.
This property is available in read-only.
ObjectArray of sfObjectSalesforce records corresponding to the result of the query.
SizeIntegerNumber of records corresponding to the result.
This property is available in read-only.

Remark: These properties can be used with one of the following syntaxes:
  • <Variable name>..<Property name>
  • <Variable name>.<Property name>

Functions that handle the sfExecuteQueryResult type

Versions 14 and later
SFExecuteQuery
New in version 14
SFExecuteQuery
SFExecuteQuery
Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.
Versions 14 and later
SFForwardQuery
New in version 14
SFForwardQuery
SFForwardQuery
Continues 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