Difference between revisions of "SQLdb tab"
From Lazarus wiki
Jump to navigationJump to searchm |
(Updated descriptions of components on SQLdb palette) |
||
Line 1: | Line 1: | ||
{{SQLdb_tab}} | {{SQLdb_tab}} | ||
{{Infobox databases}} | {{Infobox databases}} | ||
− | The '''SQLdb tab''' of the [[Component Palette]] contains non-visible database | + | 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]] | ||
Line 8: | Line 8: | ||
! Icon || Component || Description | ! Icon || Component || Description | ||
|- | |- | ||
− | | [[image:tsqlquery.png]] || [[TSQLQuery]] ||SQL | + | | [[image:tsqlquery.png]] || [[TSQLQuery]] || Needed to read/write data from/to a [[DataSet]] using SQL commands |
|- | |- | ||
− | | [[image:tsqltransaction.png]] || [[TSQLTransaction]] || | + | | [[image:tsqltransaction.png]] || [[TSQLTransaction]] || Defines how changes are transferred to the databasse |
|- | |- | ||
− | | [[image:tsqlscript.png]] || [[TSQLScript]] || Scripting | + | | [[image:tsqlscript.png]] || [[TSQLScript]] || Scripting for execution of multiple SQL commands |
|- | |- | ||
− | | [[image:tsqlconnector.png]] || [[TSQLConnector]] || | + | | [[image:tsqlconnector.png]] || [[TSQLConnector]] || General connection component; the database engine is defined by property <code>ConnectorType</code> |
|- | |- | ||
− | | [[image:tmssqlconnection.png]] || [[TMSSQLConnection]] || MS SQL | + | | [[image:tmssqlconnection.png]] || [[TMSSQLConnection]] || Connection component to '''MS SQL''' database engine |
|- | |- | ||
− | | [[image:tsybaseconnection.png]] || [[TSybaseConnection]] || Sybase | + | | [[image:tsybaseconnection.png]] || [[TSybaseConnection]] || Connection component to '''Sybase''' database engine |
|- | |- | ||
− | | [[image:tpqconnection.png]] || [[TPQConnection]] || Postgres | + | | [[image:tpqconnection.png]] || [[TPQConnection]] || Connection component to '''Postgres''' SQL server |
|- | |- | ||
− | | [[image:tpqteventmonitor.png]] || [[TPQTEventMonitor]] || Postgres | + | | [[image:tpqteventmonitor.png]] || [[TPQTEventMonitor]] || Monitors events sent from the Postgres SQL database server |
|- | |- | ||
− | | [[image:toracleconnection.png]] || [[TOracleConnection]] || Oracle | + | | [[image:toracleconnection.png]] || [[TOracleConnection]] || Connection component to '''Oracle''' database server |
|- | |- | ||
− | | [[image:todbcconnection.png]] || [[TODBCConnection]] || ODBC | + | | [[image:todbcconnection.png]] || [[TODBCConnection]] || Connection component to an '''ODBC''' (Open Database Connectivity) data source |
|- | |- | ||
− | | [[image:tmysql40connection.png]] || [[TMySQL40Connection]] || MySQL 4.0 | + | | [[image:tmysql40connection.png]] || [[TMySQL40Connection]] || Connection component to '''MySQL 4.0''' |
|- | |- | ||
− | | [[image:tmysql41connection.png]] || [[TMySQL41Connection]] || MySQL 4.1 | + | | [[image:tmysql41connection.png]] || [[TMySQL41Connection]] || Connection component to '''MySQL 4.1''' |
|- | |- | ||
− | | [[image:tmysql50connection.png]] || [[TMySQL50Connection]] || MySQL 5.0 | + | | [[image:tmysql50connection.png]] || [[TMySQL50Connection]] || Connection component to '''MySQL 5.0''' |
|- | |- | ||
− | | [[image:tmysql51connection.png]] || [[TMySQL51Connection]] || MySQL 5.1 | + | | [[image:tmysql51connection.png]] || [[TMySQL51Connection]] || Connection component to '''MySQL 5.1''' |
|- | |- | ||
− | | [[image:tmysql55connection.png]] || [[TMySQL55Connection]] || MySQL 5.5 | + | | [[image:tmysql55connection.png]] || [[TMySQL55Connection]] || Connection component to '''MySQL 5.5''' |
|- | |- | ||
− | | [[image:tmysql56connection.png]] || [[TMySQL56Connection]] || MySQL 5.6 | + | | [[image:tmysql56connection.png]] || [[TMySQL56Connection]] || Connection component to '''MySQL 5.6''' |
|- | |- | ||
− | | [[image:tsqlite3connection.png]] || [[TSQLite3Connection]] || | + | | [[image:tsqlite3connection.png]] || [[TSQLite3Connection]] || Connection component for '''SQLite3''' database files. |
|- | |- | ||
− | | [[image:tibconnection.png]] || [[TIBConnection]] || InterBase/[[Firebird]] | + | | [[image:tibconnection.png]] || [[TIBConnection]] || Connection component to '''InterBase/[[Firebird]]''' |
|- | |- | ||
− | | [[image:tfbadmin.png]] || [[TFBAdmin]] || Firebird | + | | [[image:tfbadmin.png]] || [[TFBAdmin]] || Component for Interbase/Firebird administration tasks |
|- | |- | ||
− | | [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] || Firebird | + | | [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] || Monitors events sent from the Interbase/[[Firebird]] server |
|- | |- | ||
− | | [[image:tsqldblibraryloader.png]] || [[TSQLDBLibraryLoader]] || | + | | [[image:tsqldblibraryloader.png]] || [[TSQLDBLibraryLoader]] || Specifies the names and locations of SQLDB database libraries |
|} | |} | ||
{{NavComponentPalette}} | {{NavComponentPalette}} | ||
<br/> | <br/> |
Revision as of 16:53, 10 September 2018
│
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 | |
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 |