execSQL

Execute a SQL query.

Syntax

Result result = Functions.execSQL(String query);

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 to cycle through the list of Parameters objects it contains, one per record.

Sample App

• HowTo:Use a SQL Query to List Records in a Custom Page

This sample uses the execSQL operation to populate a JSP page with a list of object records.

Learn More

• SQL Browser
• SQL Syntax
• SQL Functions