<< Click to Display Table of Contents >> Navigation:  Supported database systems > SQLite > SQLite connection properties

SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine.

 

All Dispatch data are stored in a single file SQLite file.

 

 

Database driver

Database driver must be set to SQLite.

File name

The location and name of the database file.

 

If the database does not exist, a new one will be created. Once the database has been created, Dispatch will connect to the database and create all the database objects (e.g. tables, procedures, triggers) that it requires.

Advanced

The Advanced property can be used to specify additional key/value pairs to the database driver.

 

For example, to allow multi-user access to a database, include LockingCode=Normal. To disable multi-user access, use LockingMode=Exclusive.

 

https://docwiki.embarcadero.com/RADStudio/Sydney/en/Connect_to_SQLite_database_(FireDAC)#Connection_Definition_Parameters