SQLite¶

DataFlex Reports can directly read from a SQLite database. After selecting this data source, you choose the .db file, and the tables present in the database are enumerated. In addition to tables and views, it is possible to access the data via an SQL statement. SQLite does not support stored procedures.

The above screenshot is taken using a sample database called Chinook, containing music information.