Difference between revisions of "ExecSQL"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 12: | Line 12: | ||
====Returns==== | ====Returns==== | ||
:[[Result Class|<tt>Result</tt>]] object. If the return code is greater than zero, use the [[Result_Class#getIterator]] method to cycle through the list of [[Parameters | :[[Result Class|<tt>Result</tt>]] object. If the return code is greater than zero, use the [[Result_Class#getIterator]] method to cycle through the list of [[Parameters Class|Parameters]] objects it contains, one per record. | ||
====Sample App==== | ====Sample App==== | ||
Revision as of 01:15, 8 February 2012
Execute a SQL query.
Syntax
- <syntaxhighlight lang="java" enclose="div">
Result result = Functions.execSQL(String query); </syntaxhighlight>
Parameters
- query
- The SQL query to execute.
- Learn more: SQL Syntax
Returns
- Result object. If the return code is greater than zero, use the Result_Class#getIterator method to cycle through the list of Parameters objects it contains, one per record.
Sample App
-
- This sample uses the execSQL operation to populate a JSP page with a list of object records.