Devart Forums

Hello!

Currently I have a project where I want to handle data in memory (read-only).
I use as main DB SQLite and I want to get data from TUniTable and TUniQuery without access always from the disk. Is there a way to do that -> without TVirtualTable?
Or is TVirtualTable the right way to do it.
Mainly I want to read the data one on startup - after that only making queries and access table data in memory.
Right now I make the queries and table data and store it in records in memory -> but then when I want to filter something I have to go to the list of records -> because cannot use SQL anymore..

Br,
Werner

Hello,

VirtualTable has no support for query execution. However, you can use the filter property for data filtering.
You can also create an additional in-memory SQLite database: UniConnection.Database := ':memory:' and work with it as with a regular database.