Softpedia >Windows >Programming >Other Programming Files >VirtualDAC (Virtual Data Access Components) >  Changelog

VirtualDAC (Virtual Data Access Components) Changelog

What's new in VirtualDAC (Virtual Data Access Components) 13.2.1

May 2, 2024
  • Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
  • Fixed internal bug with TSharedObject

New in VirtualDAC (Virtual Data Access Components) 13.2.0 (Apr 25, 2024)

  • Added support for RAD Studio 12 Athens Release 1
  • Added support for Lazarus 3.2
  • Added voResetAutoInc in the VirtualTable component that allows to reset AutoInc values on Clear
  • Fixed bug in VirtualQuery with querying source datasets that contain NULL column values

New in VirtualDAC (Virtual Data Access Components) 13.1.0 (Apr 25, 2024)

  • Added support for Lazarus 3.0
  • Fixed bug with empty field values when insert via the VirtualQuery component

New in VirtualDAC (Virtual Data Access Components) 13.0.0 (Nov 15, 2023)

  • Added support for RAD Studio 12
  • Added support for macOS Sonoma
  • Added support for iOS 17
  • Added support for Android 13
  • Added support for DBMonitor in the VirtualQuery component
  • Added support for storing AutoInc fields when saving TVirtualTable to XML
  • Added support for nested Macros in SQL queries
  • Added support Display Format for Aggregate fields
  • Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
  • Fixed bug "Assertion failure" when using TVirtualDataSet
  • Fixed bug with reading MySQL fields of type "bigint" to TVirtualQuery
  • Fixed bug with incorrect results in the TVirtualQuery when COLLATE NOCASE is used
  • Fixed bug with a memory leak on closing an application after using TVirtualQuery
  • Fixed bug with saving/loading fields with Unicode names in the VirtualTable component
  • Fixed bug with assigning a VirtualTable component that has persistent fields
  • Fixed bug with editing a source dataset after reopening TVirtualQuery
  • Fixed bug with inserting BLOBs using TVirtualQuery
  • Fixed bug with moving the cursor when using Aggregate fields
  • Fixed bug with deleting a record when using Aggregated fields
  • Fixed bug with storing empty Aggregates collection in DFM
  • Fixed bug with AV when installing a package in the IDE
  • Fixed bug with AV in the CloneCursor method of the dataset
  • Fixed bug with using Aggregated and InternalCalc fields together
  • Fixed bug with duplicate resource IDs in CBuilder
  • Fixed bug with using "NOT Field LIKE" construction in Filter property

New in VirtualDAC (Virtual Data Access Components) 12.3.0 (Mar 20, 2023)

  • Added support for RAD Studio 11 Alexandria Release 3
  • Added support for iOS Simulator target platform
  • Added support for Lazarus 2.2.6
  • Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
  • Added support for the mathematical operations in TDADataSet.Filter
  • Added support for Aggregate Fields and InternalCalc Fields
  • Improved the execution of statement that have either IS NULL or IS NOT NULL in the WHERE clause with TVirtualQuery
  • Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
  • Fixed bug with AV on using master/detail relationship with VirtualTable
  • Fixed bug with loading data that already has persistent fields into VirtualTable

New in VirtualDAC (Virtual Data Access Components) 12.2.0 (Sep 13, 2022)

  • Added support for RAD Studio 11 Alexandria Release 2
  • Added support for Lazarus 2.2.2
  • Added support for iOS 15
  • Added support for Android 12
  • Added support of standard collations in a SQL statement in the VirtualQuery component
  • Added the CloneCursor method for Query and Table components that allows sharing data between datasets
  • Improved the performance of exporting to XML

New in VirtualDAC (Virtual Data Access Components) 12.1.1 (Apr 12, 2022)

  • RAD Studio 11.1 Alexandria is supported
  • Lazarus 2.2.0 is supported
  • Windows 11 is supported
  • macOS Monterey is supported
  • Fixed bug with executing batch operations with the VirtualQuery component

New in VirtualDAC (Virtual Data Access Components) 12.0.2 (Dec 10, 2021)

  • Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
  • Fixed bug with using the AsDate property when working with fields of the ftDate type

New in VirtualDAC (Virtual Data Access Components) 12.0.1 (Sep 14, 2021)

  • RAD Studio 11 Alexandria is supported
  • Fixed bug with duplicate records when navigating through TVirtualDataSet for which a filter is set
  • Fixed bug with persistent fields when saving and then reading data from file to TVirtualTable
  • Fixed bug with setting a DateTime value before the year 1800 to TTimeField
  • Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
  • Fixed bug with escaping wildcards in the Filter property of the DataSet component

New in VirtualDAC (Virtual Data Access Components) 11.4.4 (Jul 16, 2021)

  • Support for TFieldOptions is added
  • Bug with the Locate method on ftLongWord fields is fixed
  • Bug with AV in the TVirtualTable.Assign method is fixed
  • Bug with AV when executing a DELETE FROM statement using TVirtualQuery is fixed
  • Bug with corrupted data of a GUID field in TVirtualDataSet is fixed

New in VirtualDAC (Virtual Data Access Components) 11.4.3 (Apr 7, 2021)

  • Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

New in VirtualDAC (Virtual Data Access Components) 11.4.2 (Mar 26, 2021)

  • Lazarus 2.0.12 is supported.

New in VirtualDAC (Virtual Data Access Components) 11.4.1 (Mar 3, 2021)

  • RAD Studio 10.4.2 Sydney is supported
  • macOS 11 Big Sur is supported
  • iOS 14 is supported
  • Android 11 is supported
  • The UseUnicode option in the VirtualQuery component is added
  • Bug with editing a source dataset after opening TVirtualQuery is fixed
  • Bug with updting a dataset with fields which contain international characters is fixed
  • Bug with processing a WHERE clause is fixed
  • Bug with editing a dataset which acts as a data source for the VirtualQuery component is fixed

New in VirtualDAC (Virtual Data Access Components) 11.3.2 (Sep 14, 2020)

  • Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required

New in VirtualDAC (Virtual Data Access Components) 11.3.1 (Sep 14, 2020)

  • Lazarus 2.0.10 and FPC 3.2.0 are supported

New in VirtualDAC (Virtual Data Access Components) 11.3.1 (Aug 27, 2020)

  • Lazarus 2.0.10 and FPC 3.2.0 are supported

New in VirtualDAC (Virtual Data Access Components) 11.2.4 (Jun 4, 2020)

  • RAD Studio 10.4 Sydney is supported
  • Lazarus 2.0.8 is supported
  • macOS 64-bit in Lazarus is supported
  • Bug with data loss in the column of type ftLargeint in the VirtualTable component in Lazarus is fixed (VirtualDAC)
  • Bug with locating a record by a fixed string column in the Chinese locale is fixed
  • Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed

New in VirtualDAC (Virtual Data Access Components) 11.1.3 (Mar 11, 2020)

  • Bug with reading a field value using the AsBytes method in Lazarus is fixed

New in VirtualDAC (Virtual Data Access Components) 11.1.2 (Nov 26, 2019)

  • Android 64-bit is supported
  • Lazarus 2.0.6 is supported
  • Now Trial edition for macOS and Linux is fully functional
  • Bug with mapping a MEMO field to a floating-point field type is fixed
  • Bug with mapping to BCD fields when TClientDataSet is used is fixed
  • Bug with resetting the range values when executing the Refresh method is fixed

New in VirtualDAC (Virtual Data Access Components) 11.0.1 (Jul 23, 2019)

  • MacOS 64-bit is supported
  • Update 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required

New in VirtualDAC (Virtual Data Access Components) 10.6.14 (Jun 24, 2019)

  • Lazarus 2.0.2 is supported
  • The DefaultSortType property for TVirtualTable is added
  • Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
  • Bug with handling BLOB fields in TVirtualTable on the Linux platform is fixed
  • Bug with attempting to save data to read-only fields when modifying a dataset is fixed
  • Bug with the AV failure when executing the Refresh method is fixed
  • Bug with calculating percentage in the OnRestoreProgress event in the TDADump class is fixed
  • Bug with the StackOverflow exception when using batch operations in CBuilder is fixed
  • Bug with using the SetRange method is fixed

New in VirtualDAC (Virtual Data Access Components) 10.5.13 (Jan 21, 2019)

  • Bug with using the datetime literals in SQL statements in TVirtualQuery is fixed

New in VirtualDAC (Virtual Data Access Components) 10.5.12 (Nov 27, 2018)

  • RAD Studio 10.3 Rio is supported
  • Support of UPPER and LOWER functions for Unified SQL is added
  • Bug with the Refresh method of TVirualQuery is fixed
  • Bug with handling BCD fields in TVirtualQuery is fixed
  • Bug with updating fields which have data type mapping in TVirtualQuery is fixed
  • Bug with saving a dataset that contains BLOB fields to XML is fixed

New in VirtualDAC (Virtual Data Access Components) 10.4.11 (Sep 18, 2018)

  • Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
  • Bug with editing data in TVirtualQuery having TVirtualTable as a source is fixed
  • Bug with mapping an error when a query contains functions like SUM is fixed
  • Bug with freezing an application when a query contains UNION ALL is fixed
  • Bug with updating data in TVirtualQuery is fixed
  • Bug with editing data in TVirtualQuery when the SELECT statement contains the ROWID column is fixed
  • Several bugs with handling BLOBs in TVirtualQuery are fixed

New in VirtualDAC (Virtual Data Access Components) 10.4.10 (Jul 13, 2018)

  • Bug with detection of field data types is fixed

New in VirtualDAC (Virtual Data Access Components) 10.4.9 (Jul 9, 2018)

  • Lazarus 1.8.4 is supported
  • The LocalUpdate property for TVirtualQuery is added
  • The AutoOpenSources option for TVirtualQuery is added
  • Bug with reading BLOB fields data on mobile platforms in TVirtualTable is fixed
  • Bug with using a backslash in the Filter property is fixed

New in VirtualDAC (Virtual Data Access Components) 10.3.8 (Apr 2, 2018)

  • Lazarus 1.8.2 is supported
  • Bug with using field aliases in the SELECT of a source dataset of TVirtualQuery is fixed
  • Bug with AV failure when ftVariant fields are used in TVirtualDataSet is fixed
  • Bug with using OR in the WHERE of a source dataset of TVirtualQuery is fixed
  • Bug with a WHERE clause with a boolean field in TVirtualQuery is fixed

New in VirtualDAC (Virtual Data Access Components) 10.3.7 (Jan 18, 2018)

  • Lazarus is supported
  • Bug with AutoInc fields in TVirtualTable is fixed
  • Bug with AV in TVirtualDataSet when editing Blob is fixed
  • Bug with a WHERE clause with a string field in TVirtualQuery is fixed
  • Bug with using a query with JOIN as a source dataset for TVirtualQuery is fixed
  • Bug with multiple LIKE in a WHERE clause for TVirtualQueryis fixed
  • Bug with re-execution of DML statements in TVirtualQuery is fixed
  • Bug with querying MS SQL Server source datasets is fixed

New in VirtualDAC (Virtual Data Access Components) 10.2.6 (Sep 19, 2017)

  • The performance of TVirtualQuery is significantly improved
  • Application-defined functions in TVirtualQuery are supported
  • Application-defined collations in TVirtualQuery are supported
  • AutoInc fields in TVirtualTable are supported
  • Bug with assertion failure when updating a record in TVirtualQuery is fixed
  • Bug with compatibility with TkbmMemTable in TVirtualQuery is fixed
  • Bug with complex WHERE clauses that have several string fields in TVirtualQuery is fixed
  • Bug with selecting from a dataset with a single record in TVirtualQuery is fixed
  • Bug with using DAC components in DataModule for Linux is fixed

New in VirtualDAC (Virtual Data Access Components) 10.1.5 (May 15, 2017)

  • Bug with using TVirtualQuery with TVirtualTable is fixed

New in VirtualDAC (Virtual Data Access Components) 10.1.4 (Apr 6, 2017)

  • RAD Studio 10.2 Tokyo is supported
  • Linux in RAD Studio 10.2 Tokyo is supported
  • Bug with processing LEFT JOIN on text fields is fixed
  • Bug with updating records with text primary key is fixed
  • Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
  • Bug with memory leak in TVirtualDataSet is fixed

New in VirtualDAC (Virtual Data Access Components) 10.0.3 (Jan 18, 2017)

  • Bug with adding Calculated fields after calling Prepare is fixed
  • Bug with reopening source dataset is fixed

New in VirtualDAC (Virtual Data Access Components) 10.0.2 (Jan 18, 2017)

  • Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
  • Bug with handling comments in a SQL statement is fixed

New in VirtualDAC (Virtual Data Access Components) 10.0.1 (Jan 18, 2017)

  • VirtualTable is renamed to VirtualDAC
  • TVirtualQuery component is added
  • TVirtualDataSet component is added

New in VirtualDAC (Virtual Data Access Components) 9.6.11 (Nov 20, 2015)

  • RAD Studio 10 Seattle is supported
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • Bug with editing Blob and Memo fields used in local filter is fixed

New in VirtualDAC (Virtual Data Access Components) 9.5.10 (Nov 20, 2015)

  • Bug with using bookmarks in a filtered dataset is fixed

New in VirtualDAC (Virtual Data Access Components) 9.5.9 (Nov 20, 2015)

  • RAD Studio XE8 is supported
  • AppMethod is supported

New in VirtualDAC (Virtual Data Access Components) 9.4.8 (Feb 6, 2015)

  • Lazarus 1.2.6 is supported
  • Bug with losing data after VirtualTable closing on SaveToStream is fixed

New in VirtualDAC (Virtual Data Access Components) 9.4.7 (Feb 6, 2015)

  • RAD Studio XE7 is supported
  • Lazarus 1.2.4 is supported

New in VirtualDAC (Virtual Data Access Components) 9.3.6 (Feb 6, 2015)

  • Support for the Upper and Lower statements in TDADataSet.Filter is added
  • Support for the ftOraTimeStamp type in TVirtualTable is added
  • Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
  • Bug with "Invalid field size" in TVirtualTable is fixed

New in VirtualDAC (Virtual Data Access Components) 9.3.5 (Feb 6, 2015)

  • RAD Studio XE6 is supported
  • Android in C++Builder XE6 is supported
  • Lazarus 1.2.2 and FPC 2.6.4 is supported
  • An option for saving all data avoiding filter is added
  • Bug with Locate when a NULL value is present in the index field is fixed

New in VirtualDAC (Virtual Data Access Components) 9.2.4 (Feb 6, 2015)

  • iOS in C++Builder XE5 is supported
  • RAD Studio XE5 Update 2 is now required
  • Now .obj and .o files are supplied for C++Builder

New in VirtualDAC (Virtual Data Access Components) 9.1.3 (Feb 6, 2015)

  • RAD Studio XE5 is supported
  • Application development for Android is supported
  • Lazarus 1.0.12 is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • The ReadOnly property is added
  • The voSetEmptyStrToNull option is added
  • Support of the IN keyword in the TDataSet.Filter property is added
  • Like operator behaviour when used in the Filter property is now similar to TClientDataSet
  • The possibility to use ranges is added

New in VirtualDAC (Virtual Data Access Components) 9.0.2 (Feb 6, 2015)

  • Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
  • Bug with time fields in Lazarus is fixed
  • Bug with varbinary fields in Lazarus is fixed
  • Bug with positioning of Fields Editor is fixed
  • Bug with processing persistent fields is fixed

New in VirtualDAC (Virtual Data Access Components) 9.0.1 (Feb 6, 2015)

  • Rad Studio XE4 is supported
  • NEXTGEN compiler is supported
  • Application development for iOS is supported
  • Support of TimeStamp, Single and Extended fields is added
  • Bug with incorrect version displaying in the About box is fixed

New in VirtualDAC (Virtual Data Access Components) 8.6 (Feb 6, 2015)

  • Rad Studio XE3 Update 2 is now required
  • C++Builder 64-bit for Windows is supported

New in VirtualDAC (Virtual Data Access Components) 8.5 (Feb 6, 2015)

  • Rad Studio XE3 is supported
  • Windows 8 is supported