Sign in Join
Wiki copytemporary

Data Access tab: what changed

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

OldNewLine
1-The **Data Access tab** of the [[Component Palette]] contains non-visible database-dataset related components.
1+---
2+[[Portal:Databases|**Databases portal**]]
3+References:
24
3-<figure>
4-<img src="Component_Palette_Data_Access.png" title="Component_Palette_Data_Access.png" />
5-<figcaption>Component_Palette_Data_Access.png</figcaption>
6-</figure>
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]]
713
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-<th><p>Online Docs</p></th>
15-</tr>
16-</thead>
17-<tbody>
18-<tr>
19-<td><figure>
20-<img src="tdatasource.png" title="tdatasource.png" />
21-<figcaption>tdatasource.png</figcaption>
22-</figure></td>
23-<td><p>[[TDataSource]]</p></td>
24-<td><p>Connects [[TDataSet]] (database contents) and [[Data Controls tab|data controls]]</p></td>
25-<td></td>
26-</tr>
27-<tr>
28-<td><figure>
29-<img src="tbufdataset.png" title="tbufdataset.png" />
30-<figcaption>tbufdataset.png</figcaption>
31-</figure></td>
32-<td><p>[[TBufDataset]]</p></td>
33-<td><p>Buffered in-memory [[TDataSet]]</p></td>
34-<td></td>
35-</tr>
36-<tr>
37-<td><figure>
38-<img src="tmemdataset.png" title="tmemdataset.png" />
39-<figcaption>tmemdataset.png</figcaption>
40-</figure></td>
41-<td><p>[[TMemDataset]]</p></td>
42-<td><p>Light-weight alternative to [[TBufDataset]]</p></td>
43-<td></td>
44-</tr>
45-<tr>
46-<td><figure>
47-<img src="tsdfdataset.png" title="tsdfdataset.png" />
48-<figcaption>tsdfdataset.png</figcaption>
49-</figure></td>
50-<td><p>[[TSdfDataSet]]</p></td>
51-<td><p>Accesses delimited text files as a [[TDataSet]]</p></td>
52-<td></td>
53-</tr>
54-<tr>
55-<td><figure>
56-<img src="tcsvdataset.png" title="tcsvdataset.png" />
57-<figcaption>tcsvdataset.png</figcaption>
58-</figure></td>
59-<td><p>[[TCSVDataSet]]</p></td>
60-<td><p>Accesses CSV text files as a [[TDataSet]]. Similar to TSdfDataset, but conforms to RFC4180 CSV</p></td>
61-<td></td>
62-</tr>
63-<tr>
64-<td><figure>
65-<img src="tfixedformatdataset.png" title="tfixedformatdataset.png" />
66-<figcaption>tfixedformatdataset.png</figcaption>
67-</figure></td>
68-<td><p>[[TFixedFormatDataSet]]</p></td>
69-<td><p>Accesses text files with fixed format records as a [[TDataSet]]</p></td>
70-<td></td>
71-</tr>
72-<tr>
73-<td><figure>
74-<img src="tdbf.png" title="tdbf.png" />
75-<figcaption>tdbf.png</figcaption>
76-</figure></td>
77-<td><p>[[TDbf]]</p></td>
78-<td><p>Accesses dBASE data files</p></td>
79-<td></td>
80-</tr>
81-<tr>
82-<td><figure>
83-<img src="tparadox.png" title="tparadox.png" />
84-<figcaption>tparadox.png</figcaption>
85-</figure></td>
86-<td><p>[[TParadox]]</p></td>
87-<td><p>Accesses PARADOX data files</p></td>
88-<td></td>
89-</tr>
90-<tr>
91-<td><figure>
92-<img src="tsqlite3dataset.png" title="tsqlite3dataset.png" />
93-<figcaption>tsqlite3dataset.png</figcaption>
94-</figure></td>
95-<td><p>[[SQLite|TSqlite3]]</p></td>
96-<td><p>Connects to SQLITE3 and its data files.</p></td>
97-<td></td>
98-</tr>
99-</tbody>
100-</table>
14+Tutorials/practical articles:
10115
102-\
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]]
10323
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+[![Component Palette Data Access.png](/wiki-images/2/25/Component_Palette_Data_Access.png)](</File:Component_Palette_Data_Access.png>)
31+
32+Icon | Component | Description | Online Docs
33+---|---|---|---
34+[![tdatasource.png](/wiki-images/d/d0/tdatasource.png)](</File:tdatasource.png>) | [[TDataSource]] | Connects [[TDataSet]] (database contents) and [[Data Controls tab|data controls]] |
35+[![tbufdataset.png](/wiki-images/6/64/tbufdataset.png)](</File:tbufdataset.png>) | [[TBufDataset]] | Buffered in-memory [[TDataSet]] |
36+[![tmemdataset.png](/wiki-images/4/41/tmemdataset.png)](</File:tmemdataset.png>) | [[TMemDataset]] | Light-weight alternative to [[TBufDataset]] |
37+[![tsdfdataset.png](/wiki-images/3/37/tsdfdataset.png)](</File:tsdfdataset.png>) | [[TSdfDataSet]] | Accesses delimited text files as a [[TDataSet]]
38+[![tcsvdataset.png](/wiki-images/d/d6/tcsvdataset.png)](</File:tcsvdataset.png>) | [[TCSVDataSet]] | Accesses CSV text files as a [[TDataSet]]. Similar to TSdfDataset, but conforms to RFC4180 CSV |
39+[![tfixedformatdataset.png](/wiki-images/d/d4/tfixedformatdataset.png)](</File:tfixedformatdataset.png>) | [[TFixedFormatDataSet]] | Accesses text files with fixed format records as a [[TDataSet]] |
40+[![tdbf.png](/wiki-images/b/bb/tdbf.png)](</File:tdbf.png>) | [[TDbf]] | Accesses dBASE data files |
41+[![tparadox.png](/wiki-images/f/f4/tparadox.png)](</File:tparadox.png>) | [[TParadox]] | Accesses PARADOX data files |
42+[![tsqlite3dataset.png](/wiki-images/8/8a/tsqlite3dataset.png)](</File:tsqlite3dataset.png>) | [[SQLite|TSqlite3]] | Connects to SQLITE3 and its data files.
43+
44+
45+
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]]
49+
10450---
105-*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).*
106-Category: Component Palette
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).*

Back to history