# 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 />

```
public interface SupportSQLiteProgram extends Closeable
```

<br />

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

|---|---|
| `https://developer.android.com/reference/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 methods |
|---|---|
| `abstract void` | `https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram#bindBlob(kotlin.Int,kotlin.ByteArray)(int index, @https://developer.android.com/reference/androidx/annotation/NonNull byte[] value)` Bind a byte array value to this statement. |
| `abstract void` | `https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram#bindDouble(kotlin.Int,kotlin.Double)(int index, double value)` Bind a double value to this statement. |
| `abstract void` | `https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram#bindLong(kotlin.Int,kotlin.Long)(int index, long value)` Bind a long value to this statement. |
| `abstract void` | `https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram#bindNull(kotlin.Int)(int index)` Bind a NULL value to this statement. |
| `abstract void` | `https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram#bindString(kotlin.Int,kotlin.String)(int index, @https://developer.android.com/reference/androidx/annotation/NonNull https://developer.android.com/reference/java/lang/String.html value)` Bind a String value to this statement. |
| `abstract void` | `https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram#clearBindings()()` Clears all existing bindings. |

### Inherited methods

From [java.io.Closeable](https://developer.android.com/reference/java/io/Closeable.html) `abstract void` `https://developer.android.com/reference/java/io/Closeable.html#close()()`

## Public methods

### bindBlob

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

```
abstract void bindBlob(int index, @NonNull byte[] value)
```

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

| Parameters |
|---|---|
| `int index` | The 1-based index to the parameter to bind |
| `@https://developer.android.com/reference/androidx/annotation/NonNull byte[] value` | 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)

```
abstract void bindDouble(int index, double value)
```

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

| Parameters |
|---|---|
| `int index` | The 1-based index to the parameter to bind |
| `double value` | The value to bind |

### bindLong

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

```
abstract void bindLong(int index, long value)
```

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

| Parameters |
|---|---|
| `int index` | The 1-based index to the parameter to bind |
| `long value` | The value to bind |

### bindNull

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

```
abstract void bindNull(int index)
```

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

| Parameters |
|---|---|
| `int index` | 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)

```
abstract void bindString(int index, @NonNull String value)
```

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

| Parameters |
|---|---|
| `int index` | The 1-based index to the parameter to bind |
| `@https://developer.android.com/reference/androidx/annotation/NonNull https://developer.android.com/reference/java/lang/String.html value` | 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)

```
abstract void clearBindings()
```

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