Sign in Join
Wiki copytemporary

SQLdb tab: what changed

Revision 0 to 1. Removed lines have a minus sign; added lines have a plus sign.

Title: SQLdb tab

OldNewLine
1+The **SQLdb tab** of the [[Component Palette]] contains non-visible components for access to "large" database systems.
2+
3+<figure>
4+<img src="Component_Palette_SQLdb.png" title="Component_Palette_SQLdb.png" />
5+<figcaption>Component_Palette_SQLdb.png</figcaption>
6+</figure>
7+
8+<table>
9+<thead>
10+<tr>
11+<th><p>Icon</p></th>
12+<th><p>Component</p></th>
13+<th><p>Description</p></th>
14+</tr>
15+</thead>
16+<tbody>
17+<tr>
18+<td><figure>
19+<img src="tsqlquery.png" title="tsqlquery.png" />
20+<figcaption>tsqlquery.png</figcaption>
21+</figure></td>
22+<td><p>[[TSQLQuery]]</p></td>
23+<td><p>Needed to read/write data from/to a [[DataSet]] using SQL commands</p></td>
24+</tr>
25+<tr>
26+<td><figure>
27+<img src="tsqltransaction.png" title="tsqltransaction.png" />
28+<figcaption>tsqltransaction.png</figcaption>
29+</figure></td>
30+<td><p>[[TSQLTransaction]]</p></td>
31+<td><p>Defines how changes are transferred to the databasse</p></td>
32+</tr>
33+<tr>
34+<td><figure>
35+<img src="tsqlscript.png" title="tsqlscript.png" />
36+<figcaption>tsqlscript.png</figcaption>
37+</figure></td>
38+<td><p>[[TSQLScript]]</p></td>
39+<td><p>Scripting for execution of multiple SQL commands</p></td>
40+</tr>
41+<tr>
42+<td><figure>
43+<img src="tsqlconnector.png" title="tsqlconnector.png" />
44+<figcaption>tsqlconnector.png</figcaption>
45+</figure></td>
46+<td><p>[[TSQLConnector]]</p></td>
47+<td><p>General connection component; the database engine is defined by property <code>ConnectorType</code></p></td>
48+</tr>
49+<tr>
50+<td><figure>
51+<img src="tmssqlconnection.png" title="tmssqlconnection.png" />
52+<figcaption>tmssqlconnection.png</figcaption>
53+</figure></td>
54+<td><p>[[TMSSQLConnection]]</p></td>
55+<td><p>Connection component to <strong>MS SQL</strong> database engine</p></td>
56+</tr>
57+<tr>
58+<td><figure>
59+<img src="tsybaseconnection.png" title="tsybaseconnection.png" />
60+<figcaption>tsybaseconnection.png</figcaption>
61+</figure></td>
62+<td><p>[[TSybaseConnection]]</p></td>
63+<td><p>Connection component to <strong>Sybase</strong> database engine</p></td>
64+</tr>
65+<tr>
66+<td><figure>
67+<img src="tpqconnection.png" title="tpqconnection.png" />
68+<figcaption>tpqconnection.png</figcaption>
69+</figure></td>
70+<td><p>[[TPQConnection]]</p></td>
71+<td><p>Connection component to <strong>Postgres</strong> SQL server</p></td>
72+</tr>
73+<tr>
74+<td><figure>
75+<img src="tpqteventmonitor.png" title="tpqteventmonitor.png" />
76+<figcaption>tpqteventmonitor.png</figcaption>
77+</figure></td>
78+<td><p>[[TPQTEventMonitor]]</p></td>
79+<td><p>Monitors events sent from the Postgres SQL database server</p></td>
80+</tr>
81+<tr>
82+<td><figure>
83+<img src="toracleconnection.png" title="toracleconnection.png" />
84+<figcaption>toracleconnection.png</figcaption>
85+</figure></td>
86+<td><p>[[TOracleConnection]]</p></td>
87+<td><p>Connection component to <strong>Oracle</strong> database server</p></td>
88+</tr>
89+<tr>
90+<td><figure>
91+<img src="todbcconnection.png" title="todbcconnection.png" />
92+<figcaption>todbcconnection.png</figcaption>
93+</figure></td>
94+<td><p>[[TODBCConnection]]</p></td>
95+<td><p>Connection component to an <strong>ODBC</strong> (Open Database Connectivity) data source</p></td>
96+</tr>
97+<tr>
98+<td><figure>
99+<img src="tmysql40connection.png" title="tmysql40connection.png" />
100+<figcaption>tmysql40connection.png</figcaption>
101+</figure></td>
102+<td><p>[[TMySQL40Connection]]</p></td>
103+<td><p>Connection component to <strong>MySQL 4.0</strong></p></td>
104+</tr>
105+<tr>
106+<td><figure>
107+<img src="tmysql41connection.png" title="tmysql41connection.png" />
108+<figcaption>tmysql41connection.png</figcaption>
109+</figure></td>
110+<td><p>[[TMySQL41Connection]]</p></td>
111+<td><p>Connection component to <strong>MySQL 4.1</strong></p></td>
112+</tr>
113+<tr>
114+<td><figure>
115+<img src="tmysql50connection.png" title="tmysql50connection.png" />
116+<figcaption>tmysql50connection.png</figcaption>
117+</figure></td>
118+<td><p>[[TMySQL50Connection]]</p></td>
119+<td><p>Connection component to <strong>MySQL 5.0</strong></p></td>
120+</tr>
121+<tr>
122+<td><figure>
123+<img src="tmysql51connection.png" title="tmysql51connection.png" />
124+<figcaption>tmysql51connection.png</figcaption>
125+</figure></td>
126+<td><p>[[TMySQL51Connection]]</p></td>
127+<td><p>Connection component to <strong>MySQL 5.1</strong></p></td>
128+</tr>
129+<tr>
130+<td><figure>
131+<img src="tmysql55connection.png" title="tmysql55connection.png" />
132+<figcaption>tmysql55connection.png</figcaption>
133+</figure></td>
134+<td><p>[[TMySQL55Connection]]</p></td>
135+<td><p>Connection component to <strong>MySQL 5.5</strong></p></td>
136+</tr>
137+<tr>
138+<td><figure>
139+<img src="tmysql56connection.png" title="tmysql56connection.png" />
140+<figcaption>tmysql56connection.png</figcaption>
141+</figure></td>
142+<td><p>[[TMySQL56Connection]]</p></td>
143+<td><p>Connection component to <strong>MySQL 5.6</strong></p></td>
144+</tr>
145+<tr>
146+<td><figure>
147+<img src="tmysql57connection.png" title="tmysql57connection.png" />
148+<figcaption>tmysql57connection.png</figcaption>
149+</figure></td>
150+<td><p>[[TMySQL57Connection]]</p></td>
151+<td><p>Connection component to <strong>MySQL 5.7</strong></p></td>
152+</tr>
153+<tr>
154+<td><figure>
155+<img src="tsqlite3connection.png" title="tsqlite3connection.png" />
156+<figcaption>tsqlite3connection.png</figcaption>
157+</figure></td>
158+<td><p>[[TSQLite3Connection]]</p></td>
159+<td><p>Connection component for <strong>SQLite3</strong> database files.</p></td>
160+</tr>
161+<tr>
162+<td><figure>
163+<img src="tibconnection.png" title="tibconnection.png" />
164+<figcaption>tibconnection.png</figcaption>
165+</figure></td>
166+<td><p>[[TIBConnection]]</p></td>
167+<td><p>Connection component to <strong>InterBase/[[Firebird]]</strong></p></td>
168+</tr>
169+<tr>
170+<td><figure>
171+<img src="tfbadmin.png" title="tfbadmin.png" />
172+<figcaption>tfbadmin.png</figcaption>
173+</figure></td>
174+<td><p>[[TFBAdmin]]</p></td>
175+<td><p>Component for Interbase/Firebird administration tasks</p></td>
176+</tr>
177+<tr>
178+<td><figure>
179+<img src="tfbeventmonitor.png" title="tfbeventmonitor.png" />
180+<figcaption>tfbeventmonitor.png</figcaption>
181+</figure></td>
182+<td><p>[[TFBEventMonitor]]</p></td>
183+<td><p>Monitors events sent from the Interbase/[[Firebird]] server</p></td>
184+</tr>
185+<tr>
186+<td><figure>
187+<img src="tsqldblibraryloader.png" title="tsqldblibraryloader.png" />
188+<figcaption>tsqldblibraryloader.png</figcaption>
189+</figure></td>
190+<td><p>[[TSQLDBLibraryLoader]]</p></td>
191+<td><p>Specifies the names and locations of SQLDB database libraries</p></td>
192+</tr>
193+</tbody>
194+</table>
195+
196+\
197+
198+---
199+*From the Free Pascal wiki, page "SQLdb tab", as it stood on 2021-07-22 after a change by Arent, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's [[Licensing]] page. If you have concerns about this material, [message the admin](/wiki-contact).*

Back to history