Devart, Czech software vendor of database tools and data connectivity solutions, released a new product in the Delphi Data Access Components product line - VirtualDAC, formerly known as VirtualTable Component. 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.
VirtualQuery. 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.
VirtualTable. 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.
VirtualDataSet. 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.
DACs updated too. The rest of the DAC products are also updated. In this version UniDAC 6.4 got the new component - TVirtualQuery. And the TVirtualDataSet component was added to all the DAC products.
Learn more about Virtual Data Access Components at https://http://www.devart.com/virtualdac/