Android.Database.Sqlite.SQLiteDatabase.CompileStatement Method
Compiles an SQL statement into a reusable pre-compiled statement object.

Syntax

[Android.Runtime.Register("compileStatement", "(Ljava/lang/String;)Landroid/database/sqlite/SQLiteStatement;", "GetCompileStatement_Ljava_lang_String_Handler")]
public virtual SQLiteStatement CompileStatement (string sql)

Parameters

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

Returns

Documentation for this section has not yet been entered.

Exceptions

TypeReason
Android.Database.SQLException

Remarks

Compiles an SQL statement into a reusable pre-compiled statement object. The parameters are identical to SQLiteDatabase.ExecSQL(string). You may put ?s in the statement and fill in those values with SQLiteProgram.BindString(int, System.String) and SQLiteProgram.BindLong(int, System.Int64) 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 Android.Database.Sqlite.SQLiteStatement at the same time.

[Android Documentation]

Requirements

Namespace: Android.Database.Sqlite
Assembly: Mono.Android (in Mono.Android.dll)
Assembly Versions: 0.0.0.0
Since: Added in API level 1