Difference between revisions of "TDataSet"
From Lazarus wiki
Jump to navigationJump to searchm (Fixed syntax highlighting; deleted category included in page template) |
|||
Line 3: | Line 3: | ||
'''TDataSet''' is the main link to the actual data in a database. A TDataSet descendant acts like a cursor on a table or query-result. | '''TDataSet''' is the main link to the actual data in a database. A TDataSet descendant acts like a cursor on a table or query-result. | ||
− | <syntaxhighlight> | + | <syntaxhighlight lang=pascal> |
SQLTransaction1.Database := SQLConnection1; | SQLTransaction1.Database := SQLConnection1; | ||
SQLQuery1.Transaction := SQLTransaction1; | SQLQuery1.Transaction := SQLTransaction1; | ||
Line 11: | Line 11: | ||
A dataset (for example a query restult) can be edited: | A dataset (for example a query restult) can be edited: | ||
− | <syntaxhighlight> | + | |
+ | <syntaxhighlight lang=pascal> | ||
ds.Edit(); | ds.Edit(); | ||
ds.FieldByName('NAME').AsString := 'Edited name'; | ds.FieldByName('NAME').AsString := 'Edited name'; | ||
Line 19: | Line 20: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
− | == | + | == Non-abstract descendants == |
+ | |||
* [[TBufDataset]] - | * [[TBufDataset]] - | ||
* [[TMemDataset]] - | * [[TMemDataset]] - | ||
Line 31: | Line 33: | ||
== See also == | == See also == | ||
+ | |||
* [[doc:fcl/db/tdataset.html|TDataSet doc]] | * [[doc:fcl/db/tdataset.html|TDataSet doc]] | ||
* [[TBufDataset]] | * [[TBufDataset]] | ||
Line 36: | Line 39: | ||
{{LCL Components}} | {{LCL Components}} | ||
− | |||
− |
Revision as of 06:18, 29 February 2020
│
English (en) │
français (fr) │
日本語 (ja) │
polski (pl) │
русский (ru) │
TDataSet is the main link to the actual data in a database. A TDataSet descendant acts like a cursor on a table or query-result.
SQLTransaction1.Database := SQLConnection1;
SQLQuery1.Transaction := SQLTransaction1;
DataSource1.'''DataSet''' := SQLQuery1;
DBGrid1.DataSource := DataSource1;
A dataset (for example a query restult) can be edited:
ds.Edit();
ds.FieldByName('NAME').AsString := 'Edited name';
ds.Post();
ds.UpdateMode := upWhereAll;
ds.ApplyUpdates();
Non-abstract descendants
- TBufDataset -
- TMemDataset -
- TSdfDataSet -
- TFixedFormatDataSet
- TDbf - connect to dBase
- TParadox - connect to Paradox/BDE
- TParadoxDataSet - connect to Paradox/BDE
- TFPCodeGenerator
- TSQLQuery - connect to results of a SQL-query
See also