Difference between revisions of "Data Access tab"

From Lazarus wiki
Jump to navigationJump to search
m
(Add missing descriptions to Data Access palette. Add TCSVDataset and TSqlite3Dataset.)
Line 7: Line 7:
 
{| class = "wikitable sortable"
 
{| class = "wikitable sortable"
 
|-
 
|-
−
! Icon !! Component !! Description
+
! Icon !! Component !! Description !! Online Docs
 
|-
 
|-
−
| [[image:tdatasource.png]] || [[TDataSource]] || connect [[TDataSet]] (database contents) and [[Data Controls tab|data controls]]
+
| [[image:tdatasource.png]] || [[TDataSource]] || connects [[TDataSet]] (database contents) and [[Data Controls tab|data controls]] ||
 
|-
 
|-
−
| [[image:tbufdataset.png]] || [[TBufDataset]] ||
+
| [[image:tbufdataset.png]] || [[TBufDataset]] || buffered in-memory [[TDataSet]] ||
 
|-
 
|-
−
| [[image:tmemdataset.png]] || [[TMemDataset]] ||
+
| [[image:tmemdataset.png]] || [[TMemDataset]] || light-weight alternative to [[TBufDataset]] ||
 
|-
 
|-
−
| [[image:tsdfdataset.png]] || [[TSdfDataSet]] ||
+
| [[image:tsdfdataset.png]] || [[TSdfDataSet]] || accesses delimited text files as a [[TDataSet]]
 
|-
 
|-
−
| [[image:tfixedformatdataset.png]] || [[TFixedFormatDataSet]] ||  
+
| [[image:tcsvdataset.png]] || [[TCSVDataSet]] || accesses CSV text files as a [[TDataSet]]. Similar to TSdfDataset, but conforms to RFC4180 CSV ||
 
|-
 
|-
−
| [[image:tdbf.png]] || [[TDbf]] || dBASE dataset connector
+
| [[image:tfixedformatdataset.png]] || [[TFixedFormatDataSet]] || access text files with fixed format records as a [[TDataSet]] ||
 +
|-
 +
| [[image:tdbf.png]] || [[TDbf]] || accesses dBASE data files ||
 +
|-
 +
| [[image:tparadox.png]] || [[TParadox]] || accesses PARADOX data files ||
 +
|-
 +
| [[image:tsqlite3dataset.png]] || [[SQLite#Using_TSQLite3Dataset|TSqlite3]] || connects to SQLITE3 and its data files.
 
|}
 
|}
  

Revision as of 22:49, 9 September 2018

│ English (en) │ français (fr) │ 日本語 (ja) │ русский (ru) │

Databases portal

References:

Tutorials/practical articles:

Databases

Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

The Data Access tab of the Component Palette contains non-visible database-dataset related components.

Component Palette Data Access.png

Icon Component Description Online Docs
tdatasource.png TDataSource connects TDataSet (database contents) and data controls
tbufdataset.png TBufDataset buffered in-memory TDataSet
tmemdataset.png TMemDataset light-weight alternative to TBufDataset
tsdfdataset.png TSdfDataSet accesses delimited text files as a TDataSet
tcsvdataset.png TCSVDataSet accesses CSV text files as a TDataSet. Similar to TSdfDataset, but conforms to RFC4180 CSV
tfixedformatdataset.png TFixedFormatDataSet access text files with fixed format records as a TDataSet
tdbf.png TDbf accesses dBASE data files
tparadox.png TParadox accesses PARADOX data files
tsqlite3dataset.png TSqlite3 connects to SQLITE3 and its data files.


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=Data_Access_tab&oldid=119086"