# SupportSQLiteProgram

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

*** ** * ** ***

<br />

```
interface SupportSQLiteProgram : Closeable
```

<br />

Known direct subclasses [SupportSQLiteStatement](https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteStatement)

|---|---|
| `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteStatement` | An interface to map the behavior of `https://developer.android.com/reference/android/database/sqlite/SQLiteStatement.html`. |

*** ** * ** ***

An interface to map the behavior of `https://developer.android.com/reference/android/database/sqlite/SQLiteProgram.html`.

## Summary

| ### Public functions |
|---|---|
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#bindBlob(kotlin.Int,kotlin.ByteArray)(index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-byte-array/index.html)` Bind a byte array value to this statement. |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#bindDouble(kotlin.Int,kotlin.Double)(index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-double/index.html)` Bind a double value to this statement. |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#bindLong(kotlin.Int,kotlin.Long)(index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html)` Bind a long value to this statement. |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#bindNull(kotlin.Int)(index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html)` Bind a NULL value to this statement. |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#bindString(kotlin.Int,kotlin.String)(index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html, value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html)` Bind a String value to this statement. |
| `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` | `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#clearBindings()()` Clears all existing bindings. |

### Inherited functions

From [java.io.Closeable](https://developer.android.com/reference/java/io/Closeable.html) `https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html` `https://developer.android.com/reference/java/io/Closeable.html#close()()`

## Public functions

### bindBlob

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

```
fun bindBlob(index: Int, value: ByteArray): Unit
```

Bind a byte array value to this statement. The value remains bound until .clearBindings is called.

| Parameters |
|---|---|
| `index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | The 1-based index to the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-byte-array/index.html` | The value to bind, must not be null |

### bindDouble

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

```
fun bindDouble(index: Int, value: Double): Unit
```

Bind a double value to this statement. The value remains bound until .clearBindings is called.

| Parameters |
|---|---|
| `index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | The 1-based index to the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-double/index.html` | The value to bind |

### bindLong

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

```
fun bindLong(index: Int, value: Long): Unit
```

Bind a long value to this statement. The value remains bound until `https://developer.android.com/reference/kotlin/androidx/sqlite/db/SupportSQLiteProgram#clearBindings()` is called. addToBindArgs

| Parameters |
|---|---|
| `index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | The 1-based index to the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html` | The value to bind |

### bindNull

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

```
fun bindNull(index: Int): Unit
```

Bind a NULL value to this statement. The value remains bound until .clearBindings is called.

| Parameters |
|---|---|
| `index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | The 1-based index to the parameter to bind null to |

### bindString

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

```
fun bindString(index: Int, value: String): Unit
```

Bind a String value to this statement. The value remains bound until .clearBindings is called.

| Parameters |
|---|---|
| `index: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html` | The 1-based index to the parameter to bind |
| `value: https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-string/index.html` | The value to bind, must not be null |

### clearBindings

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

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

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