TDataSet

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 result) 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 (needs dlls, less features, read/write)
• TParadoxDataSet - connect to Paradox/BDE (more features, read-only)
• TFPCodeGenerator
• TSQLQuery - connect to results of a SQL-query

See also

• TDataSet doc
• TBufDataset
• TMemDataset

From the Free Pascal wiki, page "TDataSet", as it stood on 2021-08-11 after a change by Arent, 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.