Switch to: V11V10V9V8V7V6V5

VSqliteStatement class: Properties

VSqliteStatement.OriginalQuery

Declaration:

OriginalQuery() as string

Description:

Returns the text of “original” sql query “as is” for this vSqliteStatement object.

Example:

v = sqlitestatement.OriginalQuery

VSqliteStatement.Query

Declaration:

Query() as string

Description:

Returns the text of “actual” sql query. Actual means - original one before Prepare() call and prepared one otherwise. Example:

INSERT INTO t1 VALUES (1); SELECT * FROM t1;

After Prepare():

INSERT INTO t1 VALUES (1);

Example:

v = sqlitestatement.Query

VSqliteStatement.UnusedQuery

Declaration:

UnusedQuery() as string

Description:

Returns the unused query part for this vSqliteStatement object.

Example:

Assume original query text is:

INSERT INTO t1 VALUES (1); SELECT * FROM t1;

After Prepare() call UnusedQuery contains:

SELECT * FROM t1;

Example:

v = sqlitestatement.UnusedQuery

VSqliteStatement.CurrentStatus

Declaration:

CurrentStatus(
	inStatus as integer ) as integer

Description:

Returns the current status of inStatus param.

Example:

v = sqlitestatement.CurrentStatus( SQLITE_STMTSTATUS_AUTOINDEX )

VSqliteStatement.Database

Declaration:

Database() as vSqliteDatabase

Description:

Returns the database which this vSqliteStatement belongs to.

Example:

v = sqlitestatement.Database