| 1 | 1 | | The **SQLdb tab** of the [[Component Palette]] contains non-visible components for access to "large" database systems. |
| 2 | 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> |
| 3 | + |  |
| 195 | 4 | | |
| 196 | | - | \ |
| 5 | + | | Icon | Component | Description | |
| 6 | + | |----|----|----| |
| 7 | + | |  | [[TSQLQuery]] | Needed to read/write data from/to a [[DataSet]] using SQL commands | |
| 8 | + | |  | [[TSQLTransaction]] | Defines how changes are transferred to the databasse | |
| 9 | + | |  | [[TSQLScript]] | Scripting for execution of multiple SQL commands | |
| 10 | + | |  | [[TSQLConnector]] | General connection component; the database engine is defined by property `ConnectorType` | |
| 11 | + | |  | [[TMSSQLConnection]] | Connection component to **MS SQL** database engine | |
| 12 | + | |  | [[TSybaseConnection]] | Connection component to **Sybase** database engine | |
| 13 | + | |  | [[TPQConnection]] | Connection component to **Postgres** SQL server | |
| 14 | + | |  | [[TPQTEventMonitor]] | Monitors events sent from the Postgres SQL database server | |
| 15 | + | |  | [[TOracleConnection]] | Connection component to **Oracle** database server | |
| 16 | + | |  | [[TODBCConnection]] | Connection component to an **ODBC** (Open Database Connectivity) data source | |
| 17 | + | |  | [[TMySQL40Connection]] | Connection component to **MySQL 4.0** | |
| 18 | + | |  | [[TMySQL41Connection]] | Connection component to **MySQL 4.1** | |
| 19 | + | |  | [[TMySQL50Connection]] | Connection component to **MySQL 5.0** | |
| 20 | + | |  | [[TMySQL51Connection]] | Connection component to **MySQL 5.1** | |
| 21 | + | |  | [[TMySQL55Connection]] | Connection component to **MySQL 5.5** | |
| 22 | + | |  | [[TMySQL56Connection]] | Connection component to **MySQL 5.6** | |
| 23 | + | |  | [[TMySQL57Connection]] | Connection component to **MySQL 5.7** | |
| 24 | + | |  | [[TSQLite3Connection]] | Connection component for **SQLite3** database files. | |
| 25 | + | |  | [[TIBConnection]] | Connection component to **InterBase/[[Firebird]]** | |
| 26 | + | |  | [[TFBAdmin]] | Component for Interbase/Firebird administration tasks | |
| 27 | + | |  | [[TFBEventMonitor]] | Monitors events sent from the Interbase/[[Firebird]] server | |
| 28 | + | |  | [[TSQLDBLibraryLoader]] | Specifies the names and locations of SQLDB database libraries | |
| 197 | 29 | | |
| 198 | 30 | | --- |
| 199 | 31 | | *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).* |
