sqlite_open — Opens an SQLite3 data base.
sqlite_open( : : FileName : SqliteHandle)
sqlite_open opens an SQLite3 data base.
If the filename is ":memory:", then a private, temporary in-memory database is created for the connection. This in-memory database will vanish when the database connection is closed. Future versions of SQLite might make use of additional special filenames that begin with the ":" character. It is recommended that when a database filename actually does begin with a ":" character you should prefix the filename with a pathname such as "./" to avoid ambiguity.
If the filename is an empty string, then a private, temporary on-disk database will be created. This private database will be automatically deleted as soon as the database connection is closed.
Find more information about the Sqlite extension package in the introduction to this chapter.
This operator returns a handle. Note that the state of an instance of this handle type may be changed by specific operators even though the handle is used as an input parameter by those operators.
FileName (input_control) filename.write → (string)
full path of the database file
Default value: ':memory:'
Suggested values: ':memory:', '', 'C:/TEMP/mydata.db'
SqliteHandle (output_control) framegrabber → (handle)
handle to a SQLite data base
sqlite_open (':memory:', SqliteHandle)
sqlite_exec (SqliteHandle, 'CREATE TABLE mytable(name TEXT, age INTEGER);', [])
sqlite_tables (SqliteHandle, Tables) // Tables = 'mytable'
Foundation