Install SQLite and create a database - database configuration/design tasks
If you are tasked with installing and configuring the database, here is a list of steps to be taken:
SQLiteInstallation (Runtime Configuration) | Parent topic: Installation (Runtime Configuration) |
If you are tasked with installing and configuring the database, here is a list of steps to be taken:
dbmsqt
database driver is linked dynamically with the SQLite library. In this case,
the SQLite shared library must be present on the system. On other platforms such as Microsoft™ Windows® and Android™, the dbmsqt
driver
has an embedded version of the SQLite library, and no SQLite library needs to be installed for
Genero applications.
$ sqlite3 /var/data/stores.db
sqlite> CREATE TABLE customer ( cust_id INT PRIMARY KEY, ... );
$ .exit
$ sqlite3 /var/data/stores.db ""
$ touch /var/data/stores.db
base.Channel
object:DEFINE ch base.Channel
LET ch = base.Channel.create()
CALL ch.openFile("/var/data/stores.db","w")
CALL ch.close