TCVSDataset
lazarus / 61-Beginners

----------------------------------------------------------------------
alanyoung · 2022-03-09 14:19

I am new to Pascal and have been trying to understand how to handle
csv files.
I have added a TCVSDataset component to Form1.  I have defined
fields.  I have added a TDataSource to Form1.
The TDataSource has its DataSet as CSVDataset1 and its Name set to
DataSource1.
I have right clicked on CSVDataset1 and selected create dataset.
The Filename associated with the CSVDataset1 exists with its full path
( and the file properties are as: -rwxrwxrwx.
After saving, compiling causes the following error:
Project project1 raised exception class ‘0000000eEDatabaseError’ with
message: Missing (compatible) underlying data, can not open
Can anyone help?  I have successfully created the usual ‘Hello World’
application, so I assume the installation was successful.

----------------------------------------------------------------------
wp · 2022-03-09 14:39

The dataset classes are quite buggy in design mode. It is highly
recommended to create fields and table at runtime. See attached
sample.

----------------------------------------------------------------------
alanyoung · 2022-03-10 17:18

Many thanks for the very prompt response.  I now understand how to
work with CSV files.
Again my thanks.