Difference between revisions of "SQLdb tab"

From Lazarus wiki
Jump to navigationJump to search
m
(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 connectors for use with [[TDataSet]] and [[TDataSource]].  
+
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 query
+
| [[image:tsqlquery.png]] || [[TSQLQuery]] || Needed to read/write data from/to a [[DataSet]] using SQL commands
 
|-
 
|-
| [[image:tsqltransaction.png]] || [[TSQLTransaction]] || Transaction
+
| [[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]] || generic connector
+
| [[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 event monitor
+
| [[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]] || SQLite
+
| [[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 admin
+
| [[image:tfbadmin.png]] || [[TFBAdmin]] || Component for Interbase/Firebird administration tasks
 
|-
 
|-
| [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] || Firebird Event monitor
+
| [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] || Monitors events sent from the Interbase/[[Firebird]] server
 
|-
 
|-
| [[image:tsqldblibraryloader.png]] || [[TSQLDBLibraryLoader]] || Library loader
+
| [[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)

Databases portal

References:

Tutorials/practical articles:

Databases

Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

The SQLdb tab of the Component Palette contains non-visible components for access to "large" database systems.

Component Palette SQLdb.png

Icon Component Description
tsqlquery.png TSQLQuery Needed to read/write data from/to a DataSet using SQL commands
tsqltransaction.png TSQLTransaction Defines how changes are transferred to the databasse
tsqlscript.png TSQLScript Scripting for execution of multiple SQL commands
tsqlconnector.png TSQLConnector General connection component; the database engine is defined by property ConnectorType
tmssqlconnection.png TMSSQLConnection Connection component to MS SQL database engine
tsybaseconnection.png TSybaseConnection Connection component to Sybase database engine
tpqconnection.png TPQConnection Connection component to Postgres SQL server
tpqteventmonitor.png TPQTEventMonitor Monitors events sent from the Postgres SQL database server
toracleconnection.png TOracleConnection Connection component to Oracle database server
todbcconnection.png TODBCConnection Connection component to an ODBC (Open Database Connectivity) data source
tmysql40connection.png TMySQL40Connection Connection component to MySQL 4.0
tmysql41connection.png TMySQL41Connection Connection component to MySQL 4.1
tmysql50connection.png TMySQL50Connection Connection component to MySQL 5.0
tmysql51connection.png TMySQL51Connection Connection component to MySQL 5.1
tmysql55connection.png TMySQL55Connection Connection component to MySQL 5.5
tmysql56connection.png TMySQL56Connection Connection component to MySQL 5.6
tsqlite3connection.png TSQLite3Connection Connection component for SQLite3 database files.
tibconnection.png TIBConnection Connection component to InterBase/Firebird
tfbadmin.png TFBAdmin Component for Interbase/Firebird administration tasks
tfbeventmonitor.png TFBEventMonitor Monitors events sent from the Interbase/Firebird server
tsqldblibraryloader.png 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