I know I can choose a local text file using a TFileComboBox. I would like to open a csv file and load the fields into a dataset. Is this possible? And if so, how can I do it?

Thanks,
Paul

Paul Coshott wrote:

> I know I can choose a local text file using a TFileComboBox. I would like to open a csv file and load the
> fields into a dataset. Is this possible? And if so, how can I do it?

Yes, it's doable.

The easy way is with my Nice library: https://erickengelke.com/nice

  io := TFileIO.Create( self );

  // next three lines load the filesaver API and notify the user if it fails
  io.scriptfilesaver.OnError := LoadScriptError;
  io.scriptfilesaver.OnLoad := LoadScriptSuccess;
  io.LoadFileSaver;

  // this upcalls your onreadload() function with the file when it is uploaded
  io.setupfilecombobox( FileComboBox1, onreadload );

But if you want to roll it yourself, which takes some experimentation, look into FileSaver.JS on the web.

Erick
EWB Programming Books and Nice Component Library
See my EWB BLOG posts, at:
http://www.erickengelke.com

erickengelke wrote:

>>The easy way is with my Nice library: https://erickengelke.com/nice
>>
>>   io := TFileIO.Create( self );

Thanks Erick. I'll have a look using your components.

Cheers,
Paul