Fan

 

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

closeSource

native Void close()

Close the statement.

executeSource

native Int execute([Str:Obj]? params := null)

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

prepareSource

native This prepare()

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

querySource

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.

queryEachSource

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.

sqlSource

readonly Str sql

The SQL text used to create this statement.