Class SqliteStatement

constructor

• new SqliteStatement(): SqliteStatement

  Returns SqliteStatement

ReadonlycolumnNames

ReadonlycolumnTypes

ReadonlydeclaredTypes

ReadonlyparamsCount

bindBlob

• bindBlob(index: number, bytes: string | ArrayBuffer | number[]): void

  Binds the blob bytes to index.

  Parameters

  • index: number

    1-based index.

  • bytes: string | ArrayBuffer | number[]

    Blob value to bind.

  Returns void

bindFloat

• bindFloat(index: number, value: number): void

  Binds the floating point value to index.

  Parameters

  • index: number

    1-based index.

  • value: number

    Floating point value to bind.

  Returns void

bindInteger

• bindInteger(index: number, value: number): void

  Binds the integer value to index.

  Parameters

  • index: number

    1-based index.

  • value: number

    Integer value to bind.

  Returns void

bindNull

• bindNull(index: number): void

  Binds a null value to index.

  Parameters

  • index: number

    1-based index.

  Returns void

bindText

• bindText(index: number, value: string): void

  Binds the text value to index.

  Parameters

  • index: number

    1-based index.

  • value: string

    Text value to bind.

  Returns void

reset

• reset(): void

  Resets internal state to allow subsequent queries.

  Returns void

step

• step(): any[]

  Either starts a new query and gets the first result, or moves to the next one.

  Returns an array containing the values in the order specified by the query, or null when the last result is reached. You should call reset() at that point if you intend to use this object again.

  Returns any[]