Difference between revisions of "Data Access tab"

From Lazarus wiki
Jump to navigationJump to search
m
m
 
(One intermediate revision by the same user not shown)
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]] || Accesses 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.
 
|}
 
|}
  

Latest revision as of 23:33, 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 Accesses 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=119101"