Recent

Author Topic: SQL Query over a bunch of TSdfDataset's  (Read 744 times)

ChristianH

  • New Member
  • *
  • Posts: 46
SQL Query over a bunch of TSdfDataset's
« 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)?

Cheers
Christian

egsuh

  • Hero Member
  • *****
  • Posts: 1266
Re: SQL Query over a bunch of TSdfDataset's
« Reply #1 on: May 10, 2022, 04:49:20 am »
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

  • Hero Member
  • *****
  • Posts: 5444
  • Compiler Developer
Re: SQL Query over a bunch of TSdfDataset's
« Reply #2 on: May 10, 2022, 09:01:09 am »
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)?

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

Zvoni

  • Hero Member
  • *****
  • Posts: 2300
Re: SQL Query over a bunch of TSdfDataset's
« Reply #3 on: May 11, 2022, 09:36:04 am »
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
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

 

TinyPortal © 2005-2018