Switch to: V9V8V7V6V5

VSqliteDatabase class: Properties

VSqliteDatabase.CurrentStatus

Declaration:

CurrentStatus(
	inStatus as integer ) as integer

Description:

Returns the current status of inStatus param.

Example:

v = sqlitedatabase.CurrentStatus( SQLITE_DBSTATUS_CACHE_USED )

VSqliteDatabase.HighestStatus

Declaration:

HighestStatus(
	inStatus as integer ) as integer

Description:

Returns the highest status of inStatus param.

Example:

v = sqlitedatabase.HighestStatus( SQLITE_DBSTATUS_CACHE_USED )

VSqliteDatabase.ConnectionCount

Declaration:

ConnectionCount as integer

Description:

Returns connection count to this db.

Example:

v = sqlitedatabase.ConnectionCount

VSqliteDatabase.StatementCount

Declaration:

StatementCount as integer

Description:

Returns VSqliteStatement count.

Example:

v = sqlitedatabase.StatementCount

VSqliteDatabase.LastInsertedRowID

Declaration:

LastInsertedRowID as integer

Description:

Returns last inserted RowID.

Example:

v = sqlitedatabase.LastInsertedRowID

VSqliteDatabase.IsOpen

Declaration:

IsOpen as boolean

Description:

Returns TRUE if the db is open.

Example:

v = sqlitedatabase.IsOpen

VSqliteDatabase.IsReadOnly

Declaration:

IsReadOnly as boolean

Description:

Returns TRUE if the db is read-only.

Example:

v = sqlitedatabase.IsReadOnly

VSqliteDatabase.Name

Declaration:

Name as string

Description:

Returns db name for remote db and fully qualified name (path + name) otherwise.

Example:

v = sqlitedatabase.Name

VSqliteDatabase.Statement

Declaration:

Statement( inStatementIndex as integer ) as VSqliteStatement

Description:

Returns vSqliteStatement by index (1-based).

Example:

v = sqlitedatabase.Statement(1)

VSqliteDatabase.AffectedRecords

Declaration:

AffectedRecords as integer

Description:

Returns affected record count after the last INSERT/UPDATE/DELETE.

Example:

v = sqlitedatabase.AffectedRecords

VSqliteDatabase.EnableSharedCache

Declaration:

EnableSharedCache as boolean
EnableSharedCache( inValue asBoolean )

Description:

Get/Set EnableSharedCache value. You can set it before db Open/Create call. In this case db will be opened/created with SQLITE_OPEN_SHAREDCACHE flag.

Example:

v = sqlitedatabase.AffectedRecords
sqlitedatabase.AffectedRecords( TRUE )

VSqliteDatabase.Exists

Declaration:

Exists as boolean

Description:

Return TRUE if database exists on the disk (it could be special location - ”:memory:” meaning in-memory db).

Example:

v = sqlitedatabase.Exists