logo

class

sql::Statement

sys::Obj
  sql::Statement

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

See docLib::Sql.

Slots

close

Void close()

Close the statement.

execute

Int execute(Str:Obj params := null)

Execute a SQL statement and if applicable return the number of rows modified.

prepare

Statement prepare()

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

query

Row[] query(Str:Obj params := null)

Execute the statement and return the resulting List of Rows. The Cols are available from List.of.fields or on type.fields of each row instance.

queryEach

Void queryEach(Str:Obj params, |Row| eachFunc)

Execute the statement. For each row in the result, invoke the specified function each. The Obj passed to the each function will be of type Row.

sql

readonly Str sql

The SQL text used to create this statement.