Share via


SQLiteDatabase.CompileStatement(String) Method

Definition

Compiles an SQL statement into a reusable pre-compiled statement object.

[Android.Runtime.Register("compileStatement", "(Ljava/lang/String;)Landroid/database/sqlite/SQLiteStatement;", "GetCompileStatement_Ljava_lang_String_Handler")]
public virtual Android.Database.Sqlite.SQLiteStatement? CompileStatement (string? sql);
[<Android.Runtime.Register("compileStatement", "(Ljava/lang/String;)Landroid/database/sqlite/SQLiteStatement;", "GetCompileStatement_Ljava_lang_String_Handler")>]
abstract member CompileStatement : string -> Android.Database.Sqlite.SQLiteStatement
override this.CompileStatement : string -> Android.Database.Sqlite.SQLiteStatement

Parameters

sql
String

The raw SQL statement, may contain ? for unknown values to be bound later.

Returns

A pre-compiled SQLiteStatement object. Note that SQLiteStatements are not synchronized, see the documentation for more details.

Attributes

Exceptions

Remarks

Compiles an SQL statement into a reusable pre-compiled statement object. The parameters are identical to #execSQL(String). You may put ?s in the statement and fill in those values with SQLiteProgram#bindString and SQLiteProgram#bindLong each time you want to run the statement. Statements may not return result sets larger than 1x1.

No two threads should be using the same SQLiteStatement at the same time.

Java documentation for android.database.sqlite.SQLiteDatabase.compileStatement(java.lang.String).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to