Hey,
so far posting here always helped me out a lot with progressing with programming in pascal so I am going to give it another shot
I have one SQLite Database with one Table. In that table I save sensorvalues of different sensors with a timestamp.
In my application I have 4 different tdbgrid components, with tcharts connected to them.
What I want to do is to display 4 different sensors all over the same time period, at the same time within the program.
A basic example:
Query1: 'select * from dbsensorreadings where sensor = forcesensor';
Query2: 'select * from dbsensorreadings where sensor = temperatursensor';
I want to display these two queries in two different tdbgrids at the same time.
I dont actually know what the best approach to this is. I have tried to create another query component (connected with a transaction and a datasource component) but that won't work. I guess it's because I actually need another dbconnection component.
But despite not getting it to work with another dbconnection component anyways, I then would have to cut the connection of one component, am I right? And that would mean loosing the values within one component, which I dont want to.
My Issue is that I don't know how to approach this problem. I hope you guys understand what I am trying to do, if not I am happy to further explain it. And I really hope you guys can point me in a way on how to do this.
Best Regards