Class Stmt

constructor

• new Stmt(sql): Stmt

• Initialize the statement with given SQL text.

  Parameters

  • sql: InSql

  Returns Stmt

sql

bindIndex

• bindIndex(index, value): Stmt

• Binds a parameter by a 1-based index.

  Parameters

  • index: number

  • value: InValue

  Returns Stmt

bindIndexes

• bindIndexes(values): Stmt

• Binds positional parameters from the given values. All previous positional bindings are cleared.

  Parameters

  • values: Iterable<InValue>

  Returns Stmt

bindName

• bindName(name, value): Stmt

• Binds a parameter by name.

  Parameters

  • name: string

  • value: InValue

  Returns Stmt

unbindAll

• unbindAll(): Stmt

• Clears all bindings.

  Returns Stmt