Difference between revisions of "SQLdb tab"

From Lazarus wiki
Jump to navigationJump to search
Line 1: Line 1:
 
{{Infobox databases}}
 
{{Infobox databases}}
−
The '''SQLdb tab''' of the [[Component Palette]] contains non-visible databaseconnectors for use with [[TDataSet]] and [[TDataSource]].  
+
The '''SQLdb tab''' of the [[Component Palette]] contains non-visible database connectors for use with [[TDataSet]] and [[TDataSource]].  
  
 
[[Image:Component_Palette_SQLdb.png]]
 
[[Image:Component_Palette_SQLdb.png]]
  
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 +
! icon || Component | Description
 
|-
 
|-
−
| [[image:tsqlquery.png]] || [[TSQLQuery]] ||  
+
| [[image:tsqlquery.png]] || [[TSQLQuery]] ||SQL query
 
|-
 
|-
−
| [[image:tsqltransaction.png]] || [[TSQLTransaction]] ||  
+
| [[image:tsqltransaction.png]] || [[TSQLTransaction]] || Transaction
 
|-
 
|-
−
| [[image:tsqlscript.png]] || [[TSQLScript]] ||  
+
| [[image:tsqlscript.png]] || [[TSQLScript]] || Scripting
 
|-
 
|-
−
| [[image:tsqlconnector.png]] || [[TSQLConnector]] ||  
+
| [[image:tsqlconnector.png]] || [[TSQLConnector]] || generic connector
 
|-
 
|-
−
| [[image:tmssqlconnection.png]] || [[TMSSQLConnection]] ||  
+
| [[image:tmssqlconnection.png]] || [[TMSSQLConnection]] || MS SQL
 
|-
 
|-
−
| [[image:tsybaseconnection.png]] || [[TSybaseConnection]] ||  
+
| [[image:tsybaseconnection.png]] || [[TSybaseConnection]] || Sybase
 
|-
 
|-
−
| [[image:tpqconnection.png]] || [[TPQConnection]] ||  
+
| [[image:tpqconnection.png]] || [[TPQConnection]] || Postgres
 
|-
 
|-
−
| [[image:tpqteventmonitor.png]] || [[TPQTEventMonitor]] ||  
+
| [[image:tpqteventmonitor.png]] || [[TPQTEventMonitor]] || Postgres event monitor
 
|-
 
|-
−
| [[image:toracleconnection.png]] || [[TOracleConnection]] ||  
+
| [[image:toracleconnection.png]] || [[TOracleConnection]] || Oracle
 
|-
 
|-
−
| [[image:todbcconnection.png]] || [[TODBCConnection]] ||  
+
| [[image:todbcconnection.png]] || [[TODBCConnection]] || ODBC
 
|-
 
|-
−
| [[image:tmysql40connection.png]] || [[TMySQL40Connection]] ||  
+
| [[image:tmysql40connection.png]] || [[TMySQL40Connection]] || MySQL 4.0
 
|-
 
|-
−
| [[image:tmysql41connection.png]] || [[TMySQL41Connection]] ||  
+
| [[image:tmysql41connection.png]] || [[TMySQL41Connection]] || MySQL 4.1
 
|-
 
|-
−
| [[image:tmysql50connection.png]] || [[TMySQL50Connection]] ||  
+
| [[image:tmysql50connection.png]] || [[TMySQL50Connection]] || MySQL 5.0
 
|-
 
|-
−
| [[image:tmysql51connection.png]] || [[TMySQL51Connection]] ||  
+
| [[image:tmysql51connection.png]] || [[TMySQL51Connection]] || MySQL 5.1
 
|-
 
|-
−
| [[image:tmysql55connection.png]] || [[TMySQL55Connection]] ||  
+
| [[image:tmysql55connection.png]] || [[TMySQL55Connection]] || MySQL 5.5
 
|-
 
|-
−
| [[image:tmysql56connection.png]] || [[TMySQL56Connection]] ||  
+
| [[image:tmysql56connection.png]] || [[TMySQL56Connection]] || MySQL 5.6
 
|-
 
|-
−
| [[image:tsqlite3connection.png]] || [[TSQLite3Connection]] ||  
+
| [[image:tsqlite3connection.png]] || [[TSQLite3Connection]] || SQLite
 
|-
 
|-
 
| [[image:tibconnection.png]] || [[TIBConnection]] || InterBase/[[Firebird]]
 
| [[image:tibconnection.png]] || [[TIBConnection]] || InterBase/[[Firebird]]
 
|-
 
|-
−
| [[image:tfbadmin.png]] || [[TFBAdmin]] ||  
+
| [[image:tfbadmin.png]] || [[TFBAdmin]] || Firebird admin
 
|-
 
|-
−
| [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] ||  
+
| [[image:tfbeventmonitor.png]] || [[TFBEventMonitor]] || Firebird Event monitor
 
|-
 
|-
−
| [[image:tsqldblibraryloader.png]] || [[TSQLDBLibraryLoader]] ||  
+
| [[image:tsqldblibraryloader.png]] || [[TSQLDBLibraryLoader]] || Library loader
 
|}
 
|}
  

Revision as of 18:15, 4 September 2016

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 database connectors for use with TDataSet and TDataSource.

Component Palette SQLdb.png

icon Description
tsqlquery.png TSQLQuery SQL query
tsqltransaction.png TSQLTransaction Transaction
tsqlscript.png TSQLScript Scripting
tsqlconnector.png TSQLConnector generic connector
tmssqlconnection.png TMSSQLConnection MS SQL
tsybaseconnection.png TSybaseConnection Sybase
tpqconnection.png TPQConnection Postgres
tpqteventmonitor.png TPQTEventMonitor Postgres event monitor
toracleconnection.png TOracleConnection Oracle
todbcconnection.png TODBCConnection ODBC
tmysql40connection.png TMySQL40Connection MySQL 4.0
tmysql41connection.png TMySQL41Connection MySQL 4.1
tmysql50connection.png TMySQL50Connection MySQL 5.0
tmysql51connection.png TMySQL51Connection MySQL 5.1
tmysql55connection.png TMySQL55Connection MySQL 5.5
tmysql56connection.png TMySQL56Connection MySQL 5.6
tsqlite3connection.png TSQLite3Connection SQLite
tibconnection.png TIBConnection InterBase/Firebird
tfbadmin.png TFBAdmin Firebird admin
tfbeventmonitor.png TFBEventMonitor Firebird Event monitor
tsqldblibraryloader.png TSQLDBLibraryLoader Library loader
Component Palette
Standard - Additional - Common Controls - Dialogs - Data Controls - Data Access - System - Misc - LazControls - RTTI - SQLdb - Pascal Script - SynEdit - Chart - IPro
Retrieved from "http://wiki.freepascal.org/index.php?title=SQLdb_tab&oldid=103860"