| 1 | | - | --- |
| 2 | | - | [[Portal:Databases|**Databases portal**]] |
| 3 | | - | References: |
| 4 | | - | |
| 5 | | - | * [[Databases|General info]] |
| 6 | | - | * [[Database libraries|Libraries]] |
| 7 | | - | * [[Database field type|Field types]] |
| 8 | | - | * [[Data Controls tab|Controls]] |
| 9 | | - | * [[Lazarus DB Faq|FAQ]] |
| 10 | | - | * [[SqlDBHowto|SQL how-to]] |
| 11 | | - | * [[Working With TSQLQuery]] |
| 12 | | - | * [[How to write in-memory database applications in Lazarus/FPC|In-memory database applications]] |
| 13 | | - | |
| 14 | | - | Tutorials/practical articles: |
| 15 | | - | |
| 16 | | - | * [[Lazarus Database Overview|Overview]] |
| 17 | | - | * [[SQLdb Tutorial0|0 - Database set-up]] |
| 18 | | - | * [[SQLdb Tutorial1|1 - Getting started]] |
| 19 | | - | * [[SQLdb Tutorial2|2 - Editing]] |
| 20 | | - | * [[SQLdb Tutorial3|3 - Queries]] |
| 21 | | - | * [[SQLdb Tutorial4|4 - Data modules]] |
| 22 | | - | * [[SQLdb Programming Reference]] |
| 23 | | - | |
| 24 | | - | Databases |
| 25 | | - | |
| 26 | | - | [[Advantage Database Server|Advantage]] \- [[MySQLDatabases|MySQL]] \- [[mssqlconn|MSSQL]] \- [[postgres|Postgres]] \- [[Firebird|Interbase]] \- [[Firebird]] \- [[Oracle]] \- [[ODBCConn|ODBC]] \- [[TParadox|Paradox]] \- [[SQLite]] \- [[Lazarus Tdbf Tutorial|dBASE]] \- [[MS Access]] \- [[Zeos tutorial|Zeos]] |
| 27 | | - | |
| 28 | | - | The **Data Access tab** of the [[Component Palette]] contains non-visible database-dataset related components. |
| 29 | | - | |
| 30 | | - | [](</File:Component_Palette_Data_Access.png>) |
| 1 | + | The **Data Access tab** of the [[Component Palette]] contains non-visible database-dataset related components. |
| 31 | 2 | | |
| 32 | | - | Icon | Component | Description | Online Docs |
| 33 | | - | ---|---|---|--- |
| 34 | | - | [](</File:tdatasource.png>) | [[TDataSource]] | Connects [[TDataSet]] (database contents) and [[Data Controls tab|data controls]] | |
| 35 | | - | [](</File:tbufdataset.png>) | [[TBufDataset]] | Buffered in-memory [[TDataSet]] | |
| 36 | | - | [](</File:tmemdataset.png>) | [[TMemDataset]] | Light-weight alternative to [[TBufDataset]] | |
| 37 | | - | [](</File:tsdfdataset.png>) | [[TSdfDataSet]] | Accesses delimited text files as a [[TDataSet]] |
| 38 | | - | [](</File:tcsvdataset.png>) | [[TCSVDataSet]] | Accesses CSV text files as a [[TDataSet]]. Similar to TSdfDataset, but conforms to RFC4180 CSV | |
| 39 | | - | [](</File:tfixedformatdataset.png>) | [[TFixedFormatDataSet]] | Accesses text files with fixed format records as a [[TDataSet]] | |
| 40 | | - | [](</File:tdbf.png>) | [[TDbf]] | Accesses dBASE data files | |
| 41 | | - | [](</File:tparadox.png>) | [[TParadox]] | Accesses PARADOX data files | |
| 42 | | - | [](</File:tsqlite3dataset.png>) | [[SQLite|TSqlite3]] | Connects to SQLITE3 and its data files. |
| 43 | | - | |
| 44 | | - | |
| 3 | + |  |
| 45 | 4 | | |
| 46 | | - | [[Component Palette]] |
| 47 | | - | --- |
| 48 | | - | [[Standard tab|Standard]] \- [[Additional tab|Additional]] \- [[Common Controls tab|Common Controls]] \- [[Dialogs tab|Dialogs]] \- [[Data Controls tab|Data Controls]] \- Data Access \- [[System tab|System]] \- [[Misc tab|Misc]] \- [[LazControls tab|LazControls]] \- [[RTTI tab|RTTI]] \- [[SQLdb tab|SQLdb]] \- [[Pascal Script tab|Pascal Script]] \- [[SynEdit tab|SynEdit]] \- [[Chart tab|Chart]] \- [[IPro tab|IPro]] |
| 5 | + | | Icon | Component | Description | Online Docs | |
| 6 | + | |----|----|----|----| |
| 7 | + | |  | [[TDataSource]] | Connects [[TDataSet]] (database contents) and [[Data Controls tab|data controls]] | | |
| 8 | + | |  | [[TBufDataset]] | Buffered in-memory [[TDataSet]] | | |
| 9 | + | |  | [[TMemDataset]] | Light-weight alternative to [[TBufDataset]] | | |
| 10 | + | |  | [[TSdfDataSet]] | Accesses delimited text files as a [[TDataSet]] | | |
| 11 | + | |  | [[TCSVDataSet]] | Accesses CSV text files as a [[TDataSet]]. Similar to TSdfDataset, but conforms to RFC4180 CSV | | |
| 12 | + | |  | [[TFixedFormatDataSet]] | Accesses text files with fixed format records as a [[TDataSet]] | | |
| 13 | + | |  | [[TDbf]] | Accesses dBASE data files | | |
| 14 | + | |  | [[TParadox]] | Accesses PARADOX data files | | |
| 15 | + | |  | [[SQLite|TSqlite3]] | Connects to SQLITE3 and its data files. | | |
| 49 | 16 | | |
| 50 | 17 | | --- |
| 51 | | - | *From the Free Pascal wiki, page "Data Access tab", as the Internet Archive kept it on 2024-01-21. 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).* |
| 18 | + | *From the Free Pascal wiki, page "Data Access tab", as it stood on 2018-09-09 after a change by Wp, 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).* |
| 19 | + | Category: Component Palette |
