execSQL

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

• 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