class isql::Statement

sys::Obj
  isql::Statement

Statement is an executable statement for a specific database. A statement may be executed immediately or prepared and executed later with parameters. See pod-doc.

addBatch

This addBatch()

close

Void close()

Close the statement.

execute

Int execute()

Execute a SQL statement and return number of rows modified.

executeBatch

Void executeBatch()

getGeneratedKeys

ResultSet getGeneratedKeys()

Get the auto generate keys

limit

Int? limit

Maximum number of rows returned when this statement is executed. If limit is exceeded rows are silently dropped. A value of null indicates no limit.

query

ResultSet query()

Execute the statement and return the resulting ResultSet

set

This set(Int i, Obj? val)

Prepare this statement by compiling for efficient execution. Return this.

sql

This sql(Str sql)

Set the sql