Data module

Databases portal

References: General info Libraries Field types Controls FAQ SQL how-to Working With TSQLQuery In-memory database applications Tutorials/practical articles: Overview 0 - Database set-up 1 - Getting started 2 - Editing 3 - Queries 4 - Data modules SQLdb Programming Reference Databases Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

A data module is a database specific kind of pascal unit. Much like a TForm you can drop components on it, as long as they are non-visible.

Typically a data module might contain a TSQLConnector (or a specialized one) and a TSQLTransaction.

A new data module can be created using File|New...

The datamodule above contains three database related items:

• TSQLTransaction
• TSQLConnector
• TSQLScript

SQLScript1 sets its transaction to SQLTransaction1 and its DataBase to SQLConnector1