# SQLiteStatement

Artifact: [androidx.sqlite:sqlite](https://developer.android.com/jetpack/androidx/releases/sqlite) [View Source](https://cs.android.com/search?q=file:androidx/sqlite/SQLiteStatement.+class:androidx.sqlite.SQLiteStatement) Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

*** ** * ** ***

Common/AllAndroid/JVMNative/C/iOSJavaScript
- Cmn

  ```
  interface SQLiteStatement : AutoCloseable
  ```

*** ** * ** ***

SQLite statement definition.

A prepared statement is a resource that must be released once it is no longer needed via its `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#close()` function.

See also [Prepared Statement](https://www.sqlite.org/c3ref/stmt.html)

## Summary

| ### Public functions |
|---|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindBlob(kotlin.Int,kotlin.ByteArray)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-byte-array/index.html)` Binds a ByteArray value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindBoolean(kotlin.Int,kotlin.Boolean)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html)` Binds a Boolean value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindDouble(kotlin.Int,kotlin.Double)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-double/index.html)` Binds a Double value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindFloat(kotlin.Int,kotlin.Float)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-float/index.html)` Binds a Float value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindInt(kotlin.Int,kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Binds a Int value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindLong(kotlin.Int,kotlin.Long)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html)` Binds a Long value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindNull(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Binds a NULL value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#bindText(kotlin.Int,kotlin.String)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html)` Binds a String value to this statement at an index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#clearBindings()()` Clears all parameter bindings. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#close()()` Closes the statement. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-byte-array/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getBlob(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getBlob(kotlin.Int)` as a ByteArray. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getBoolean(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getBoolean(kotlin.Int)` as a Boolean. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnCount()()` Returns the number of columns in the result of the statement. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnName(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the name of a column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnName(kotlin.Int)` in the result of the statement. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html<https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html>` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnNames()()` Returns the name of the columns in the result of the statement ordered by their index. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnType(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the data type of a column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnType(kotlin.Int)` in the result of the statement. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-double/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getDouble(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getDouble(kotlin.Int)` as a Double. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-float/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getFloat(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getFloat(kotlin.Int)` as a Float. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getInt(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getInt(kotlin.Int)` as a Int. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getLong(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getLong(kotlin.Int)` as a Long. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getText(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getText(kotlin.Int)` as a String. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#isNull(kotlin.Int)(index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Returns true if the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#isNull(kotlin.Int)` is NULL. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#reset()()` Resets the prepared statement back to initial state so that it can be re-executed via `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.ranges/index.html`. | Cmn JS |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#step()()` Executes the statement and evaluates the next result row if available. | Cmn |
| `suspend https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#step()()` Executes the statement asynchronously and evaluates the next result row if available. | JS |

| ### Extension functions |
|---|---|---|
| `suspend https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement.https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#(androidx.sqlite.SQLiteStatement).step()()` Executes the statement and evaluates the next result row if available. | Cmn JS |

## Public functions

### bindBlob

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindBlob(index: @IntRange(from = 1) Int, value: ByteArray): Unit
```

Binds a ByteArray value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-byte-array/index.html` | the value to bind |

### bindBoolean

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindBoolean(index: @IntRange(from = 1) Int, value: Boolean): Unit
```

Binds a Boolean value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | the value to bind |

### bindDouble

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindDouble(index: @IntRange(from = 1) Int, value: Double): Unit
```

Binds a Double value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-double/index.html` | the value to bind |

### bindFloat

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindFloat(index: @IntRange(from = 1) Int, value: Float): Unit
```

Binds a Float value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-float/index.html` | the value to bind |

### bindInt

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindInt(index: @IntRange(from = 1) Int, value: Int): Unit
```

Binds a Int value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the value to bind |

### bindLong

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindLong(index: @IntRange(from = 1) Int, value: Long): Unit
```

Binds a Long value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html` | the value to bind |

### bindNull

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindNull(index: @IntRange(from = 1) Int): Unit
```

Binds a NULL value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |

### bindText

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun bindText(index: @IntRange(from = 1) Int, value: String): Unit
```

Binds a String value to this statement at an index.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 1) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 1-based index of the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html` | the value to bind |

### clearBindings

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun clearBindings(): Unit
```

Clears all parameter bindings. Unset bindings are treated as NULL.

### close

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun close(): Unit
```

Closes the statement.

Once a statement is closed it should no longer be used. Calling this function on an already closed statement is a no-op.

### getBlob

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getBlob(index: @IntRange(from = 0) Int): ByteArray
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getBlob(kotlin.Int)` as a ByteArray.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-byte-array/index.html` | the value of the column |

### getBoolean

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getBoolean(index: @IntRange(from = 0) Int): Boolean
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getBoolean(kotlin.Int)` as a Boolean.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | the value of the column |

### getColumnCount

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getColumnCount(): Int
```

Returns the number of columns in the result of the statement.

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the number of columns |

### getColumnName

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getColumnName(index: @IntRange(from = 0) Int): String
```

Returns the name of a column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnName(kotlin.Int)` in the result of the statement.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html` | the name of the column |

### getColumnNames

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getColumnNames(): List<String>
```

Returns the name of the columns in the result of the statement ordered by their index.

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html<https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html>` | the names of the columns |

### getColumnType

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getColumnType(index: @IntRange(from = 0) Int): Int
```

Returns the data type of a column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getColumnType(kotlin.Int)` in the result of the statement.

The data type can be used to determine the preferred `get*()` function to be used for the column but other getters may perform data type conversion.

Value is one of the following:

- `1`
- `2`
- `3`
- `4`
- `5`

<br />

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the data type of the column |

### getDouble

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getDouble(index: @IntRange(from = 0) Int): Double
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getDouble(kotlin.Int)` as a Double.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-double/index.html` | the value of the column |

### getFloat

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getFloat(index: @IntRange(from = 0) Int): Float
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getFloat(kotlin.Int)` as a Float.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-float/index.html` | the value of the column |

### getInt

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getInt(index: @IntRange(from = 0) Int): Int
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getInt(kotlin.Int)` as a Int.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the value of the column |

### getLong

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getLong(index: @IntRange(from = 0) Int): Long
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getLong(kotlin.Int)` as a Long.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html` | the value of the column |

### getText

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun getText(index: @IntRange(from = 0) Int): String
```

Returns the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#getText(kotlin.Int)` as a String.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html` | the value of the column |

### isNull

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun isNull(index: @IntRange(from = 0) Int): Boolean
```

Returns true if the value of the column at `https://developer.android.com/reference/kotlin/androidx/sqlite/SQLiteStatement#isNull(kotlin.Int)` is NULL.

| Parameters |
|---|---|
| `index: @https://developer.android.com/reference/kotlin/androidx/annotation/IntRange(from = 0) https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | the 0-based index of the column |

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | true if the column value is NULL, false otherwise |

### reset

Cmn JS Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun reset(): Unit
```

Resets the prepared statement back to initial state so that it can be re-executed via `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.ranges/index.html`. Any parameter bound via the `bind*()` APIs will retain their value.

### step

Cmn Added in [2.5.0](https://developer.android.com/jetpack/androidx/releases/sqlite#2.5.0)

```
fun step(): Boolean
```

Executes the statement and evaluates the next result row if available.

A statement is initially prepared and compiled but is not executed until one or more calls to this function. If the statement execution produces result rows then this function will return `true` indicating there is a new row of data ready to be read.

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | true if there are more rows to evaluate or false if the statement is done executing |

### step

JS

```
suspend fun step(): Boolean
```

Executes the statement asynchronously and evaluates the next result row if available.

A statement is initially prepared and compiled but is not executed until one or more calls to this function. If the statement execution produces result rows then this function will return `true` indicating there is a new row of data ready to be read.

| Returns |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html` | true if there are more rows to evaluate or false if the statement is done executing |

## Extension functions

### SQLiteStatement.step

Cmn JS Artifact: [androidx.sqlite:sqlite-async](https://developer.android.com/jetpack/androidx/releases/sqlite) [View Source](https://cs.android.com/search?q=file:androidx/sqlite/async/SQLiteAsync.+function:step)

```
suspend fun SQLiteStatement.step(): Boolean
```

Executes the statement and evaluates the next result row if available.

On web targets this function is asynchronous while for non-web it is synchronous.