Built-In Object Type: DBQuery

Inherits All
(MORE DESCRIPTION TO COME.)
Methods:
NameArgumentsDescription
close
  Closes this prepared statement.
dumpResult
fileName
limit
promptSegment
Dumps the whole result or up to limit rows into a tableDump file. If fileName is not specified, use the table name (of the first column) suffixed with ".tdmp". The optional promptSegment is an integer such as 100; if specified, whenever every so many rows are saved to the file, a dot indicator is printed to system out. This is a helpful hint for large table dumping which can take a long while.
getColumnAttributes
getColumnAttrs
  Returns the column attributes for this query as an instance of TableData.
getPreparedStatement
  Returns the prepared statement (an instance of java.sql.PreparedStatement) for this query.
getResult
limit
This is a convenience method that returns the whole result or up to limit, if specified; the result is either an array if the result has only one column, or a TableData if multiple columns are selected.
getResultSet
  Returns the result set (an instance of java.sql.ResultSet) of the last query run.
getResultSetMetaData
  Returns the meta data for the result set (an instance of java.sql.ResultSet) of the last query run.
getResultSetType
  Returns the result set type, which is one of these: "forward_only", "scroll_insensitive" or "scroll_sensitive".
getSQL
  Returns the SQL statement for this query.
hasResult
  Returns true if the last run has results.
next
  Returns true if the result still has rows, and moves the result set pointer to the next row. Valied only after a run.