Switch to: V9V8V7V6V5

VSqliteDatabase Class: SQL Methods

VSqliteDatabase.CreateStatement()

Declaration:

CreateStatement( inQuery as string )

Parameters:

  • inQuery - The SQL string of a query.

Description:

Creates a new vSqliteStatement object.

Example:

v = db.CreateStatement( 'SELECT * FROM t1' )

VSqliteDatabase.CloseStatement()

Declaration:

CloseStatement( inSqliteStatement as VSqliteStatement )

Parameters:

  • inSqliteStatement - The vSqliteStatement which was created in this database.

Description:

Close vSqliteStatement.

Example:

v = db.CreateStatement( 'SELECT * FROM t1' )
db.CloseStatement( v )

VSqliteDatabase.SqlExecute()

Declaration:

SqlSqliteExecute( inQuery as String )

Parameters:

  • inQuery - The SQL string of a query.

Description:

Execute all the commands in inQuery directly (without creating a statement). It is just sort of “syntax sugar” to simplify executing sql-statements.

Example:

db.SQLExecute( "UPDATE person SET name = 'john' 
                           WHERE name = 'jehn'" )