Export the dataset (MySQL) using LCL DbExport components fccsvexporter to CSV lazarus / 31-LCL ---------------------------------------------------------------------- tmac1959 · 2013-07-22 16:45 Hi, I need to export the dataset (MySQL) using LCL DbExport components fccsvexporter to CSV format. Using this code exports the entire dataset but I could not find anywhere manual for this component to define TExportFieldItem and export only selected fields. procedure TForm1.MenuItem17Click(Sender: TObject); begin      SaveDialogCSVSave.Execute;      CSVExporterVysklPredana.FileName:=SaveDialogCSVSave.FileName;      CSVExporterVysklPredana.Execute;      CSVExporterVysklPredana.Cancel; end;                Thanks for the link to the manual or code ---------------------------------------------------------------------- ludob · 2013-07-22 18:24 Populate the CSVExporterVysklPredana.ExportFields collection with the fields you want to export. Or populate it automatically with (Dataset has to be set): Code: [Select]   CSVExporterVysklPredana.BuildDefaultFieldMap(CSVExporterVysklPredana .ExportFields); and set then the Code: [Select]CSVExporterVysklPredana.ExportFields[i].Enabled:=false for the fields you want to skip. The name of the field is in Code: [Select]CSVExporterVysklPredana.ExportFields[i].FieldName.