Properties TASQLiteDatabase

property ASQLiteLog

Optional. Connector for a ASQLiteLog component.

property ASQLitePragma

Optional. Connector for a ASQLitePragma component.

property  Connected

Set property to 'true' to connect to a SQLite database. Other option: use the method 'open'.

property  Database

Full path and databasename of the database to be accessed. It is a pulldown property showing all available database including ':memory:' to access the full database in-memory. See next property.

property DefaultDir

Default directory to look for databases. Will be used to create database path with property database.

property  DefaultExt

Default extension of files which are considered to be a SQLite database. It is used for the pulldown property 'database' to enumerate all available databases (*.ext)

property  Version

Read-only. After opening the database this property is filled with the installed version of the SQLite database.

property  CharacterEncoding

Read-only. After opening the database this property is filled with the installed Character Encoding (see also the SQLite documentation. This parameter is set at compiling time of SQLite).

property  DriverDLL

Path and filename of the SQLite library. Default sqlite.dll

property  MustExist

If a SQLite database does not exists it will automatically be created (default behaviour of SQLite). This property will prevent this from happening. Set to 'true' if an exception must be triggered if the database does not exist.

property Name

Name of the component (standard Delphi)

property Tag

Tag (standard Delphi)

property  AfterConnect

Event triggered after connecting to a database

property  BeforeConnect

Event triggered before connecting to a database

property  AfterDisconnect

Event triggered after disconnecting to a database

property  BeforeDisconnect

Event triggered before connecting to a database

Methods

Open

Open a connection

Close

Closes a connection

StartTransaction

Start beginning of a new transaction (nested transactions are not supported by SQLite)

Commit

Commit transaction

RollBack

Rollback transaction

GetTableNames

GetTableNames(List: TStrings; SystemTables: Boolean = False);
Enumerates all tables within the selected database. The SystemTables has no function yet, just for compatibility with Borland TDatabase object.

GetIndexNames

GetIndexNames(List: TStrings; SystemTables: Boolean = False);
Enumerates all indexes within the selected database. The SystemTables has no function yet, just for compatibility with Borland TDatabase object.

GetFieldNames

GetFieldNames(TableName : string; List: TStrings);
Enumerates all fields within the selected table.