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

native Void close()

Close the statement.

Source

execute

native Int execute(Str:Obj params := null)

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

Source

prepare

native Statement prepare()

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

Source

query

native 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.

Source

queryEach

native 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.

Source

sql

readonly Str sql

The SQL text used to create this statement.

Source