PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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.
Note: See Declaring a variable for more details.
Versions 20 and later
WINDEVLinux This type of variable is now available for the WINDEV applications in Linux.
iPhone/iPad This type of variable is now available for the iPhone/iPad applications.
New in version 20
WINDEVLinux This type of variable is now available for the WINDEV applications in Linux.
iPhone/iPad This type of variable is now available for the iPhone/iPad applications.
WINDEVLinux This type of variable is now available for the WINDEV applications in Linux.
iPhone/iPad This type of variable is now available for the iPhone/iPad applications.
Example
// Connect 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

// 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 stringLocation of the query. 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.
Note: 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 required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment