VolgaDB Engine - TVolgaTable, TVolgaQuery, TVolgaServQuery, TVolgaDatabase components and Volga Data Desktop utility for local access to flat files in own format without BDE, or client-side dataset for MS SQL, MySQL or MS Access databases.

• all standard properties, methods,events of TDataSet, it can works with any visual DB-aware controls
• fast native access to data without BDE and compact file format, supporting strings, numbers, dates, memos, images, etc.;
• record range and filter, master-detail relationship;
• sort-on-the-fly in ascending and descending order, record search, context find, locate and lookup;
• cached updates;
• copying of the current record to a new one;
• temporary in-memory tables that can later be saved in a file;
• cloning of another TVolgaDataset, batch move operation;
• loading and saving files in Volga format, automatic backup;
• callback events for indication loading process;
• borrow structure and save to file at design time.

                                                               

• password protection with ciphering;
• autoincremental fields support;
• reverting records, show deleted records, OldValue property for fields, IsChanged property;
• check key violation, check existing duplicate records with same field values
• loading and saving files in Volga in stream
• FindFirst, FindNext, FindPrior, FindLast, FindNearest, GotoNearest, filter as expression;
• save external objects in RecordData property for any record;
• save any arbitrary text within Volga table.
• group operations: sum field values over all records, get list of values from records selected in event handler.
• exporting data to text, DBF, XML, Excel files;
• creating a new table aggregating ("group by") another table;
• TVolgaQuery executes SQL queries in Volga database (Volga files located in one directory). SQL language is a subset of standard ANSI SQL;
• edit, sort, range, master-detail, filter operations on query result as a table;
• cached updates which can be saved in one (original) table;
• restructuring tables in code.