sqlite_load_dbT_sqlite_load_dbSqliteLoadDbSqliteLoadDb (Operator)

Name

sqlite_load_dbT_sqlite_load_dbSqliteLoadDbSqliteLoadDb — Loading of a database on disk into a previously opened database.

Signature

sqlite_load_db( : : FileNameRestore, SqliteHandle : )

Herror T_sqlite_load_db(const Htuple FileNameRestore, const Htuple SqliteHandle)

void SqliteLoadDb(const HTuple& FileNameRestore, const HTuple& SqliteHandle)

static void HHdevguiServerExtpack.SqliteLoadDb(HTuple fileNameRestore, HTuple sqliteHandle)

Description

sqlite_load_dbsqlite_load_dbSqliteLoadDbSqliteLoadDbSqliteLoadDb loads a database specified as file in FileNameRestoreFileNameRestoreFileNameRestoreFileNameRestorefileNameRestore into an open database specified in SqliteHandleSqliteHandleSqliteHandleSqliteHandlesqliteHandle. This is particulary useful to load a database on disk into an in-memory database created with ':memory:'":memory:"":memory:"":memory:"":memory:" in sqlite_opensqlite_openSqliteOpenSqliteOpenSqliteOpen.

If loading fails, the error H_ERR_FNF (5200) will be returned. An error message will be output in the HDevelop Output Console, see set_systemset_systemSetSystemSetSystemSetSystem parameter 'do_low_error'"do_low_error""do_low_error""do_low_error""do_low_error".

Find more information about the Sqlite extension package in the introduction to this chapter.

Execution Information

Parameters

FileNameRestoreFileNameRestoreFileNameRestoreFileNameRestorefileNameRestore (input_control)  filename.read HTupleHTupleHtuple (string) (string) (HString) (char*)

full path of the database file

Default value: 'C:/TEMP/mydata.db' "C:/TEMP/mydata.db" "C:/TEMP/mydata.db" "C:/TEMP/mydata.db" "C:/TEMP/mydata.db"

Suggested values: 'C:/TEMP/mydata.db'"C:/TEMP/mydata.db""C:/TEMP/mydata.db""C:/TEMP/mydata.db""C:/TEMP/mydata.db"

SqliteHandleSqliteHandleSqliteHandleSqliteHandlesqliteHandle (input_control)  framegrabber HTupleHTupleHtuple (handle) (IntPtr) (HHandle) (handle)

handle to a SQLite data base

Module

Foundation