SQL Query over a bunch of TSdfDataset's
lazarus / 16-Databases

----------------------------------------------------------------------
ChristianH · 2022-05-09 20:07

I am aware that this might be sound as dumb, but to be honest the last
time I was working with the TDatabase is 15 years ago.
How can I put multiple TSdfDatasets into one TDatabase in order do a
sql query over the dataset(tables)?

Cheers
Christian

----------------------------------------------------------------------
egsuh · 2022-05-10 02:49

I'm afraid it's not possible with Lazarus/Free Pascal. Delphi used
several separate FireFox tables under one folder and set relationships
within them, but not sure Lazarus supplies such features.

----------------------------------------------------------------------
PascalDragon · 2022-05-10 07:01

Quote from: ChristianH on May 09, 2022, 10:07:27 pmI am aware that
this might be sound as dumb, but to be honest the last time I was
working with the TDatabase is 15 years ago.
How can I put multiple TSdfDatasets into one TDatabase in order do a
sql query over the dataset(tables)?
Maybe you can cook something up with ZMSQL, but I can't tell you how.

----------------------------------------------------------------------
Zvoni · 2022-05-11 07:36

Why not use SQLite as an intermediary?
Read the Text-File (CSV?) line by line (or load it into a StringList)
and throw it into a SQLite InMemory-Database.

If you don't want dependencies, then it's Do it by hand, since the
TDataSet-property of TDatabase is ReadOnly

Everything depending on the Amount and Complexity of Data