InternalSQLiteLibraryMBS.CompileOption(index as Integer) as String

Var list() as string

for i as Integer = 0 to 100
  Var s as string = InternalSQLiteLibraryMBS.CompileOption(i)
  if s = "" then exit
  Var b as Boolean = InternalSQLiteLibraryMBS.CompileOptionUsed(s)
  Var t as string
  if b then
    t = ": yes"
  else
    t = ": no"
  end if
  list.Append s + t
next

MsgBox Join(list, EndOfLine)

Index index starting with zero until you get back an empty name.

Some examples using this method:

• /SQL/SQLite Internal Library Compiler Options

InternalSQLiteLibraryMBS.CompileOptionUsed(optionName as String) as Boolean

Var list() as string

for i as Integer = 0 to 100
  Var s as string = InternalSQLiteLibraryMBS.CompileOption(i)
  if s = "" then exit
  Var b as Boolean = InternalSQLiteLibraryMBS.CompileOptionUsed(s)
  Var t as string
  if b then
    t = ": yes"
  else
    t = ": no"
  end if
  list.Append s + t
next

MsgBox Join(list, EndOfLine)

If you need a specific option set, please contact MBS support.

Some examples using this method:

• /SQL/SQLite Internal Library Compiler Options

InternalSQLiteLibraryMBS.DumpToFile(SqliteDBConectionHandle as Ptr, File as FolderItem, TableName as string = "", PreserveRowid as Boolean = false, Newlines as Boolean = false, DumpDataOnly as Boolean = false, DumpNoSys as Boolean = false)

Call InternalSQLiteLibraryMBS.Use

Var con As New SQLConnectionMBS

// connect....

Var handle As ptr = con.SQLiteConnectionHandle
Var file As FolderItem = SpecialFolder.Desktop.Child("dump.txt")
InternalSQLiteLibraryMBS.DumpToFile(handle, file)

Must use the internal SQLite database, otherwise it will crash.
Raises exception if handle or file is nil.
SQL errors are output by SQLite to the output file.

InternalSQLiteLibraryMBS.DumpToString(SqliteDBConectionHandle as Ptr, byref Data as String, MaximumSize as Integer = 10000000, TableName as string = "", PreserveRowid as Boolean = false, Newlines as Boolean = false, DumpDataOnly as Boolean = false, DumpNoSys as Boolean = false)

Call InternalSQLiteLibraryMBS.Use

Var con As New SQLConnectionMBS

// connect....

Var handle As ptr = con.SQLiteConnectionHandle
Var data as string
InternalSQLiteLibraryMBS.DumpToFile(handle, data, 1000000)

Must use the internal SQLite database, otherwise it will crash.
Raises exception if handle is nil or we run out of memory.
SQL errors are output by SQLite to the output file.

Please pass size of memory we should allocate. Then we can run the dump.
if the final COMMIT is missing or the size is close to the limit you gave, you may run again with higher limit.

InternalSQLiteLibraryMBS.DumpToStrings(SqliteDBConectionHandle as Ptr, SchemaName as String = "", TableName as string = "") as String()

Schema: Which schema to dump. Usually "main".
Table: Which table to dump. Pass "" for all tables.

This subroutine converts the content of an SQLite database into UTF-8 text SQL statements that can be used to exactly recreate the original database. ROWID values are preserved.

The connection handle parameter is the SQLite database connection using our internal SQLite library. Schema is the schema within that database which is to be dumped. Usually the zSchema is "main" but can also be "temp" or any ATTACH-ed database. If Table is not empty, then only the content of that one table is dumped. If zTable is empty, then all tables are dumped.

The generate text is collected and returned as a string array.

InternalSQLiteLibraryMBS.isKeyword(name as string) as boolean

if InternalSQLiteLibraryMBS.isKeyword("TABLE") then
  MsgBox "Table is a keyword"
else
  MsgBox "Table is not a keyword!"
end if

InternalSQLiteLibraryMBS.Keywords as String()

MsgBox Join(InternalSQLiteLibraryMBS.Keywords,EndOfLine)

InternalSQLiteLibraryMBS.LoadICU as Boolean

If InternalSQLiteLibraryMBS.ICULoaded Then
  MessageBox "already loaded"
ElseIf InternalSQLiteLibraryMBS LoadICU Then
  MessageBox "loaded successfully"
Else
  MessageBox "failed to load the unicode libraries."
End If

Returns true on success.
Normally we load them when SQLite initializes and we then add the ICU extension if we find the library.
Call this function toe explicit load them now.

If MBS Plugin can find International Components for Unicode library files, we can load them and use them for proper unicode handling in SQLite.

InternalSQLiteLibraryMBS.SourceID as String

MsgBox InternalSQLiteLibraryMBS.SourceID

InternalSQLiteLibraryMBS.Use as boolean

if InternalSQLiteLibraryMBS.Use then
  MsgBox "Using internal SQLite"
else
  MsgBox "Failed, so please use library file."
end if

So instead of having SQL Plugin load sqlite3 shared library from file, we use the one built into this plugin.

InternalSQLiteLibraryMBS.Version as String

MsgBox InternalSQLiteLibraryMBS.Version

InternalSQLiteLibraryMBS.VersionNumber as Integer

MsgBox str(InternalSQLiteLibraryMBS.VersionNumber)