Difference between revisions of "SQLdb tab"
From Lazarus wiki
Jump to navigationJump to search(11 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | The '''SQLdb tab''' of the [[Component Palette]] contains non-visible | + | {{SQLdb_tab}} |
+ | {{Infobox databases}} | ||
+ | The '''SQLdb tab''' of the [[Component Palette]] contains non-visible components for access to "large" database systems. | ||
[[Image:Component_Palette_SQLdb.png]] | [[Image:Component_Palette_SQLdb.png]] | ||
− | + | {| class="wikitable sortable" | |
− | + | ! Icon || Component || Description | |
− | + | |- | |
− | + | | [[image:tsqlquery.png]] || [[TSQLQuery]] || Needed to read/write data from/to a [[DataSet]] using SQL commands | |
− | + | |- | |
− | + | | [[image:tsqltransaction.png]] || [[TSQLTransaction]] || Defines how changes are transferred to the databasse | |
− | + | |- | |
− | + | | [[image:tsqlscript.png]] || [[TSQLScript]] || Scripting for execution of multiple SQL commands | |
− | + | |- | |
− | + | | [[image:tsqlconnector.png]] || [[TSQLConnector]] || General connection component; the database engine is defined by property <code>ConnectorType</code> | |
− | + | |- | |
− | + | | [[image:tmssqlconnection.png]] || [[TMSSQLConnection]] || Connection component to '''MS SQL''' database engine | |
− | + | |- | |
− | + | | [[image:tsybaseconnection.png]] || [[TSybaseConnection]] || Connection component to '''Sybase''' database engine | |
− | + | |- | |
− | + | | [[image:tpqconnection.png]] || [[TPQConnection]] || Connection component to '''Postgres''' SQL server | |
− | + | |- | |
− | + | | [[image:tpqteventmonitor.png]] || [[TPQTEventMonitor]] || Monitors events sent from the Postgres SQL database server | |
− | + | |- | |
− | + | | [[image:toracleconnection.png]] || [[TOracleConnection]] || Connection component to '''Oracle''' database server | |
− | + | |- | |
+ | | [[image:todbcconnection.png]] || [[TODBCConnection]] || Connection component to an '''ODBC''' (Open Database Connectivity) data source | ||
+ | |- | ||
+ | | [[image:tmysql40connection.png]] || [[TMySQL40Connection]] || Connection component to '''MySQL 4.0''' | ||
+ | |- | ||
+ | | [[image:tmysql41connection.png]] || [[TMySQL41Connection]] || Connection component to '''MySQL 4.1''' | ||
+ | |- | ||
+ | | [[image:tmysql50connection.png]] || [[TMySQL50Connection]] || Connection component to '''MySQL 5.0''' | ||
+ | |- | ||
+ | | [[image:tmysql51connection.png]] || [[TMySQL51Connection]] || Connection component to '''MySQL 5.1''' | ||
+ | |- | ||
+ | | [[image:tmysql55connection.png]] || [[TMySQL55Connection]] || Connection component to '''MySQL 5.5''' | ||
+ | |- | ||
+ | | [[image:tmysql56connection.png]] || [[TMySQL56Connection]] || Connection component to '''MySQL 5.6''' | ||
+ | |- | ||
+ | | [[image:tmysql57connection.png]] || [[TMySQL57Connection]] || Connection component to '''MySQL 5.7''' | ||
+ | |- | ||
+ | | [[image:tsqlite3connection.png]] || [[TSQLite3Connection]] || Connection component for '''SQLite3''' database files. | ||
+ | |- | ||
+ | | [[image:tibconnection.png]] || [[TIBConnection]] || Connection component to '''InterBase/[[Firebird]]''' | ||
+ | |- | ||
+ | | [[image:tfbadmin.png]] || [[TFBAdmin]] || Component for Interbase/Firebird administration tasks | ||
+ | |- | ||
+ | | [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] || Monitors events sent from the Interbase/[[Firebird]] server | ||
+ | |- | ||
+ | | [[image:tsqldblibraryloader.png]] || [[TSQLDBLibraryLoader]] || Specifies the names and locations of SQLDB database libraries | ||
+ | |} | ||
{{NavComponentPalette}} | {{NavComponentPalette}} | ||
− | + | <br/> | |
− |
Latest revision as of 21:48, 22 July 2021
│
English (en) │
français (fr) │
русский (ru) │
References:
Tutorials/practical articles:
Databases |
The SQLdb tab of the Component Palette contains non-visible components for access to "large" database systems.
Icon | Component | Description |
---|---|---|
TSQLQuery | Needed to read/write data from/to a DataSet using SQL commands | |
TSQLTransaction | Defines how changes are transferred to the databasse | |
TSQLScript | Scripting for execution of multiple SQL commands | |
TSQLConnector | General connection component; the database engine is defined by property ConnectorType
| |
TMSSQLConnection | Connection component to MS SQL database engine | |
TSybaseConnection | Connection component to Sybase database engine | |
TPQConnection | Connection component to Postgres SQL server | |
TPQTEventMonitor | Monitors events sent from the Postgres SQL database server | |
TOracleConnection | Connection component to Oracle database server | |
TODBCConnection | Connection component to an ODBC (Open Database Connectivity) data source | |
TMySQL40Connection | Connection component to MySQL 4.0 | |
TMySQL41Connection | Connection component to MySQL 4.1 | |
TMySQL50Connection | Connection component to MySQL 5.0 | |
TMySQL51Connection | Connection component to MySQL 5.1 | |
TMySQL55Connection | Connection component to MySQL 5.5 | |
TMySQL56Connection | Connection component to MySQL 5.6 | |
TMySQL57Connection | Connection component to MySQL 5.7 | |
TSQLite3Connection | Connection component for SQLite3 database files. | |
TIBConnection | Connection component to InterBase/Firebird | |
TFBAdmin | Component for Interbase/Firebird administration tasks | |
TFBEventMonitor | Monitors events sent from the Interbase/Firebird server | |
TSQLDBLibraryLoader | Specifies the names and locations of SQLDB database libraries |
Component Palette |
---|
Standard - Additional - Common Controls - Dialogs - Data Controls - Data Access - System - Misc - LazControls - RTTI - SQLdb - Pascal Script - SynEdit - Chart - IPro |