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

Sample Code

This sample code is a template for query processing. It retrieves a value from the most recent record that matches the specified criteria:

try {
   String latest_value;
   String sql = 
      "SELECT some_field FROM MyObject " +
      "WHERE another_field = '" + someValue + "' " +
      "ORDER BY date_created DESC " +            
      "LIMIT 1";
   Result result = Functions.execSQL(sql);
   int resultCode = result.getCode();
   if (resultCode < 0)
   {
      // Error occurred
      String msg = "Sample: Error during SQL search";
      Functions.debug("Sample:\n" + result.getMessage());
   }
   else if (resultCode > 0)
   {
      // A record was found. (Else resultCode == 0)                     
      // Invert the value of the last flag for this run
      ParametersIterator it = result.getIterator();
      Parameters params = it.next();  // Use a loop if Limit > 1       
      latest_value = params.get("some_field");
      Functions.debug("Sample: latest value = " + latest_value);        
   }
} catch (Exception e) {
   String msg = project + ": Exception during SQL search";
   Functions.debug("Sample:\n" + e.getMessage());        
}

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