SFExecuteQuery (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Possible error cases:

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SFExecuteQuery (Function)

In french: SFExécuteRequête

Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.

Versions 20 and later

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

New in version 20

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

Versions 24 and later

This function is now available for WEBDEV sites in Linux.

New in version 24

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 the variable of type sfConnection to be used.

<Query to run>: Character string

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: wd270ggl.dll