Using index with TCSVDataSet
lazarus / 16-Databases

----------------------------------------------------------------------
Vodnik · 2023-01-13 14:00

Hello!
My program have to scan a directory structure for XML-files, extract
some data from them and fill them into the table or DB for user
search. Customer asked for "something very simple" and I decided to
use TCSVDataSet.
Soon I discovered that indexes can be created for it. What I can't
understand - where they are stored? And do they?
When TCSVDataSet is closed, data is stored in CSV-file, but there is
no index file created. Is index lost when TCSVDataSet is closed?

----------------------------------------------------------------------
Vodnik · 2023-01-14 17:36

Some light on this was shed here:
https://forum.lazarus.freepascal.org/index.php?topic=23425.0