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
Data in memory without TVirtualTable?
Re: Data in memory without TVirtualTable?
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.
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.