Returns a list of all resulting objects of the SQL query to the data source. Each object represents a row of the result. These objects can be accessed by methods that match the requested column names of the data source object. For calculated column names the method property(<column name>) is available.
Example:
The result of perform('select ArticleNumber, Vendor from [Article$] where Vendor=\'Mind8\';') can be accessed by the methods ArticleNumber and Vendor.
perform(String sqlStatement) | ||||
---|---|---|---|---|
Argument | String | sqlStatement | SQL query to the data source | |
Return value | List |
Formula | Result |
---|---|
|
|