The new Product is released! The formerly known VirtualTable becomes - VirtualDAC, with 2 more components...
VirtualDAC consists of components that provide such capabilities as working with non-tabular data, performing SQL-queries to data in memory or to data from sources in different RDBMS'es etc., that are not available for standard data access components. In addition to the well-known TVirtualTable component, VirtualDAC is supplemented with two new components - TVirtualQuery and TVirtualDataSet.
The TVirtualQuery component is used to retrieve data with SQL queries from sources, that are any TDataSet descendants. Due to this, you can build complex SQL queries to in-memory data (data sources are TVirtualTable, TVirtualDataSet or another TVirtualQuery) or to data stored in different RDBMS'es.
The TVirtualTable component represents an in-memory data storage that does not have linked data files. TVirtualTable allows to load data from a XML or CSV file, or from an existing dataset, and then process the data in the usual way, as in any TDataSet descendant.
The TVirtualDataSet component is data wrapper that doesn't store data in memory and interacts with data using event handlers. It allows to represent arbitrary data (arrays, lists, objects, etc.) as TDataSet descendants and link it with any DB-aware components to display data or modify it.
Devart development team