Lazarus DB Faq
This FAQ covers database programming with Lazarus.
Where can I find more FAQ?
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.
- See Lazarus_Database_Overview for a list of what databases are supported by SQLDB.
Are there other components?
- See Lazarus_Database_Overview for a list of what databases work with what components.
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
- Some information on the interaction between the various FPC and Lazarus components: SQLdb Programming Reference