Lazarus DB Faq

This is a list of Frequently Asked Questions (FAQ) regarding database programming with Lazarus.

Where can I find more information?

Databases:

• See Databases and the articles about using databases/SQLQuery.

Where can I find database components?

At the moment the SQLdb components are part of FPC and Lazarus. They are installed by default in all more or less recent Lazarus versions.

Manual installation: if you look in the [$LazarusDir]/components you will see a subdirectory SQLdb. Install the sqldblaz.lpk and you will be able to connect to MySQL, Interbase / Firebird, Postgres, MS SQL and Sybase ASE (if you have FPC 2.6.1+), Oracle servers. See Install Packages for help on installing packages.

Supported databases

• See Lazarus Database Overview for a list of what databases are supported by SQLDB.

Known issues

• See fcl-db#Known%20issues/shortcomings

Are there other components?

• See Lazarus Database Overview for a list of what databases work with what components.

Lazarus and FPC documentation

The Lazarus visual database controls use FPC database code. Please see SQLDB documentation for more information.

Background info on SQLDB: SqlDBHowto

More info on TSQLQuery: Working With TSQLQuery

Lazarus documentation

• Some information on the interaction between the various FPC and Lazarus components: SQLdb Programming Reference

---

From the Free Pascal wiki, page "Lazarus DB Faq", as it stood on 2016-08-15 after a change by Arent, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's Licensing page. If you have concerns about this material, message the admin.