Forum > Databases

SQL Query over a bunch of TSdfDataset's

(1/1)

ChristianH:
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:
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:

--- Quote from: ChristianH on May 09, 2022, 10:07:27 pm ---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)?
--- End quote ---

Maybe you can cook something up with ZMSQL, but I can't tell you how.

Zvoni:
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

Navigation

[0] Message Index

Go to full version