Softpedia >Windows >Programming >Components & Libraries >MySQL Data Access Components >  Changelog

MySQL Data Access Components Changelog

What's new in MySQL Data Access Components 12.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 MySQL Data Access Components 12.2.0 (Apr 25, 2024)

  • Added support for RAD Studio 12 Athens Release 1
  • Added support for Lazarus 3.2
  • Fixed bug with incorrect executing of internal Rollback

New in MySQL Data Access Components 12.1.0 (Feb 19, 2024)

  • Lazarus 3.0 is supported
  • Fixed bug with getting warning message of using bmBinary mode
  • Fixed bug with assertion failure or AV in batch operation

New in MySQL Data Access Components 12.0.0 (Nov 15, 2023)

  • Added support for RAD Studio 12
  • Added support for MariaDB 11
  • Added support for macOS Sonoma
  • Added support for iOS 17
  • Added support for Android 13
  • Added support for the mysql_clear_password authentication mechanism
  • 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 with write BLOB when using the SJIS charset
  • Fixed bug with connecting to the MySQL 8 by a user with an empty password using mysql_native_password authentication mechanism
  • Fixed the bug when TMySQLMonitor.OnSQL event does not occur upon executing TMyConnection.ExecSQL method with no parameters
  • 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 MySQL Data Access Components 11.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
  • Added ability to restore from file with TEncoding via the Dump component
  • Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
  • Fixed bug with BLOBs for MySQL version below 4.1
  • Fixed bug with BIGINT UNSIGNED key fields in version 4.1 or higher
  • Fixed bug with BIT field default values

New in MySQL Data Access Components 11.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 the CloneCursor method for Query and Table components that allows sharing data between datasets
  • Improved the performance of exporting to XML
  • Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption
  • Fixed bug with truncation of milliseconds of DateTime fields in the Dump component
  • Fixed bug with posting calculated field
  • Fixed bug when a connection string parameter value contains a single quote

New in MySQL Data Access Components 11.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 fkInternalCalc field after calling the Refresh method
  • Fixed bug with resetting param values when changing param values count
  • Fixed bug with a "Refresh failed" on Post when RefreshOption = roAfterInsert and SQL contains the same PK more than once
  • Fixed bug with an "Unknown column" when adding record containing calculated field when RefreshOption = roAfterInsert
  • Fixed bug with HTTPS tunneling in the Direct mode
  • Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

New in MySQL Data Access Components 11.0.2 (Dec 9, 2021)

  • The PoolId connection pool option is added
  • Fixed bug with an "Unknown column" error when adding record when RefreshOption = roAfterInsert
  • Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
  • Fixed bug with freezing multiply connection pools in threads
  • Fixed bug with using the AsDate property when working with fields of the ftDate type
  • Fixed bug with updating the state of records at applying cached updates

New in MySQL Data Access Components 11.0.1 (Sep 14, 2021)

  • RAD Studio 11 Alexandria is supported
  • macOS ARM is supported
  • Added demo project for FastReport FMX
  • Fixed bug with an "Unknown column" error on Post when RefreshOption = roAfterInsert
  • 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 memoty leak on Locate by field with data type mapping
  • Fixed bug with escaping wildcards in the Filter property of the DataSet component

New in MySQL Data Access Components 10.4.4 (Jul 15, 2021)

  • Support for TFieldOptions is added
  • Bug with applying both Encryption and Data Type Mapping on a BLOB column is fixed
  • Bug with AV after adding the Lookup field to a prepared DataSet is fixed

New in MySQL Data Access Components 10.4.3 (Apr 7, 2021)

  • Demo compatibility with new a version of SecureBridge is fixed
  • Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

New in MySQL Data Access Components 10.4.2 (Mar 26, 2021)

  • Lazarus 2.0.12 is supported
  • Bug with the "Prepared statement contains too many placeholders" error in batch operations is fixed
  • Bug with the ConvertEOL connection option is fixed
  • Bug with AV in applications using DBMonitor is fixed
  • Bug with committing a transaction when LockMode = lmPessimistic is fixed
  • Bug with getting values of calculated fields is fixed

New in MySQL Data Access Components 10.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 LastWarningCount property in TMyConnection is added
  • The OnWarning event in TMyConnection is added
  • Performance of batch operations is improved
  • Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
  • Bug with the 'TableName cannot be empty' assertion when opening a query is fixed
  • Bug with dumping DOUBLE fields in the TMyDump component when UseUnicode set to True is fixed
  • Bug with processing data that includes international characters on Linux is fixed
  • Bug with AV failure when using OpenSSL 1.1 libraries is fixed
  • Bug with getting parameters for a procedure or function in MySQL 5.0.45 is fixed
  • Bug with setting the ReadOnly field property at runtime is fixed

New in MySQL Data Access Components 10.3.2 (Sep 15, 2020)

  • Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
  • Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed
  • Bug with values getting cut off after calling the SHOW CREATE FUNCTION statement for MySQL 5.0.x is fixed

New in MySQL Data Access Components 10.3.1 (Aug 27, 2020)

  • Lazarus 2.0.10 and FPC 3.2.0 are supported
  • Performance of Batch Insert, Update, and Delete operations is improved

New in MySQL Data Access Components 10.2.4 (Jun 2, 2020)

  • RAD Studio 10.4 Sydney is supported
  • Lazarus 2.0.8 is supported
  • macOS 64-bit in Lazarus is supported
  • Bug with an invalid refresh query for calculated fields if the roBeforeEdit option is set is fixed
  • 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 MySQL Data Access Components 10.1.3 (Mar 11, 2020)

  • Bug with installing different editions of two or more DAC's in a single system is fixed
  • Bug with TMyDump when the TMyDump.Options.FieldsAsString = True is fixed
  • Bug with an empty error message when invoking the TMyQuery.Prepare method is fixed
  • Bug with handling comments in a SQL statement is fixed
  • Bug with SQL statements that contain fields with the same name from different tables is fixed
  • Bug with executing SQL statements that contain comments using the Script component is fixed
  • Bug with resetting the value of the parameter after adding a new TDACondition is fixed
  • Bug with reading a field value using the AsBytes method in Lazarus is fixed
  • Bug with using constraints after calling the Refresh method is fixed

New in MySQL Data Access Components 10.1.2 (Nov 26, 2019)

  • OpenSSL 1.1 library is supported
  • A package containing the TMySSHIOHandler and TMySSLIOHandler components for Lazarus is added
  • The TMyConnection.GetStoredProcNames and TMyConnection.GetTriggerNames methods are added
  • Bug with freezing of the TMyConnection design-time editor for MySQL versions older than 4.1 is fixed
  • Bug with international characters in error messages when UseUnocode = True is fixed
  • Bug with AV failure when using encryption is fixed
  • Bug with using the FieldOrigins property is fixed
  • Bug with the Loader component when UniDirectional set to True for source dataset is fixed
  • Bug with "Record changed by another user" error when LockMode <> lmNone 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
  • Several bugs that occurred when using DataSet Manager are fixed

New in MySQL Data Access Components 10.0.1 (Jul 23, 2019)

  • Update 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
  • Bug with using the AsMemo method in batch operations is fixed

New in MySQL Data Access Components 9.4.10 (Jun 24, 2019)

  • Lazarus 2.0.2 is supported
  • Performance of TMyDump for data dumping from a query is improved
  • Performance of describing stored procedures is improved
  • Multi-threading support is improved
  • The DefaultSortType property for TVirtualTable is added
  • Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
  • Bug with processing data that include international symbols when using the EUCKR charset is fixed
  • Bug with memory leak when using an SSL connection is fixed
  • Bug with updating a dataset containing a composite primary key is fixed
  • Bug with using the STATUS literal in a query 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 MySQL Data Access Components 9.3.9 (Jan 21, 2019)

  • Bug with setting the data type of the parameter to BOOLEAN for all TINYINT system data types in the functions is fixed
  • Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed

New in MySQL Data Access Components 9.2.8 (Nov 27, 2018)

  • RAD Studio 10.3 Rio is supported
  • Support for PAM and Windows authentications is added
  • Support of UPPER and LOWER functions for Unified SQL is added
  • TMyConnection.OnDialogAuthPlugin event is added
  • Bug in TMyDump with backuping stored procedures in MySQL 8 is fixed
  • Bug with describing binary fields is fixed
  • Bug with using the FieldOrigins property is fixed
  • Bug with using the TrimFixedChar property is fixed
  • Bug with saving a dataset that contains BLOB fields to XML is fixed

New in MySQL Data Access Components 9.2.7 (Sep 18, 2018)

  • Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
  • Now the SetRange method supports Null values
  • The enumerated property FieldOrigins is added
  • The Boolean property FieldsOrigin is deprecated
  • Bug with AV when using custom constraints is fixed
  • Bug with filling default values in MariaDB 10.2.7 and higher for Delphi 7 and older is fixed

New in MySQL Data Access Components 9.2.6 (Jul 9, 2018)

  • Lazarus 1.8.4 is supported
  • MySQL 8 is supported
  • Support for sha2_password, caching_sha2_password authentications is added
  • Performance of batch operations is improved
  • Demo projects for IntraWeb 14 are added
  • Bug with application freezing when using stored procedure is fixed
  • Bug with using the LongStrings option is fixed
  • Bug with updating a record when using the OnFilterRecord event handler is fixed
  • Bug with using encryption and CacheCalcFields option is fixed
  • Bug with using a backslash in the Filter property is fixed
  • Bug with using First method in the Master-Detail relationship is fixed

New in MySQL Data Access Components 9.1.5 (Apr 2, 2018)

  • Lazarus 1.8.2 is supported
  • Now Detail dataset is not refreshed when Master dataset editing is started.
  • Bug with executing batch operations with iteration = 1 and offset = 0 is fixed
  • Bug with re-opening a filtered dataset is fixed
  • Bug with data decryption in SmartFetch mode is fixed
  • Bug with data truncation while decrypting is fixed
  • Bug with creating the list of tables when using TMyServerControl is fixed
  • Bug with multiple calls of the SetOrderBy method in RAD Studio 10.2 Tokyo is fixed
  • Bug with assertion failure when executing the prepared query as the field data type is changed is fixed

New in MySQL Data Access Components 9.1.4 (Jan 18, 2018)

  • Lazarus 1.8 and FPC 3.0.4 are supported
  • Support for custom constraints is added
  • The UseBlankValues property for the Loader component is added
  • Bug with filling default values when TDADataSetOptions.DefaultValues = True for MariaDB 10.2.7 and higher is fixed
  • Bug with parsing SQL that contains a table name with spaces after the point is fixed
  • Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
  • Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
  • Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
  • Bug with assertion failure when using the OnFilterRecord event handler is fixed
  • Bug with script parsing in TDAScript is fixed
  • Bug with AutoInc fields in TVirtualTable is fixed
  • Bug with AV in TVirtualDataSet when editing Blob is fixed

New in MySQL Data Access Components 9.1.3 (Sep 19, 2017)

  • Azure Database for MySQL is supported
  • JSON data type is supported
  • Bug with Assert when calling the Refresh method after changing fields amount of recordset (stored procedure) is fixed
  • Bug with generating SQL for batch updates is fixed
  • Bug with the Locate method for non-Windows platforms in Lazarus is fixed
  • Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed
  • Bug with accessing a product help from the IDE menu is fixed
  • Bug with recreating fields when calling Open after Prepare is fixed
  • Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed
  • Bug with AV failure when using calculated fields in TClientDataset is fixed
  • Bug with a key violation error when executing batch operations is fixed
  • Bug with Assert when calling the Locate method in the SmartFetch mode is fixed
  • Bug with using DAC components in DataModule for Linux is fixed

New in MySQL Data Access Components 9.0.2 (May 15, 2017)

  • Bug with processing DATETIME fields is fixed
  • Bug with international characters in TMyDump is fixed
  • Bug with assertion failure when enabled dbForge Studio integration is fixed
  • Bug with processing NULL values in the Loader component is fixed
  • Bug with executing a query after executing a batch command is fixed
  • Bug with using the AsGuid property is fixed

New in MySQL Data Access Components 9.0.1 (Apr 6, 2017)

  • RAD Studio 10.2 Tokyo is supported
  • Linux in RAD Studio 10.2 Tokyo is supported
  • Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
  • Support for HTTPS protocol is added
  • Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
  • Bug with detecting parameters by name in ExecSQLEx is fixed
  • Bug with reading Memo as WideMemo is fixed
  • Bug with field name quoting in a filter expression is fixed
  • Bug with handling parameter values of BLOB type in batch operations is fixed
  • Bug with memory leak in TVirtualDataSet is fixed
  • Bug in the design-time editor of the TMyEmbConnection component is fixed

New in MySQL Data Access Components 8.7.27 21-Nov-16 (Jan 18, 2017)

  • Bug with adding Calculated fields after calling Prepare is fixed
  • Bug with executing batch updates and deletes on old versions of MySQL is fixed

New in MySQL Data Access Components 8.7.26 01-Nov-16 (Jan 18, 2017)

  • Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
  • Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
  • Bug with processing TIMESTAMP and DATETIME fields is fixed
  • Bug with loading data from a pipe is fixed
  • SSL support is fixed

New in MySQL Data Access Components 8.7.25 08-Sep-16 (Jan 18, 2017)

  • TDADataSetOptions.InsertAllSetFields property is added
  • Several bugs in SmartFetch Mode are fixed
  • Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
  • Bug with param values loss after changing TDAParam.ValueCount is fixed
  • Bug with PtrOffset function when Overflow Checking option enabled is fixed
  • Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
  • Bug with the duplicated MacroChar variable is fixed
  • Bug with RowsAffected calculation after executing the RefreshQuick method is fixed
  • Bug with processing MEDIUMTEXT fields when UseUnicode is True is fixed
  • Bug with processing DATETIME fields is fixed
  • Bug with processing TIMESTAMP(1)..TIMESTAMP(5) fields is fixed

New in MySQL Data Access Components 8.7.24 27-Jun-16 (Jan 18, 2017)

  • TVirtualDataSet component is added
  • Bug with assertion failure on editing data in SmartFetch mode is fixed
  • Bug with using parameters and column aliases in Master-Detail relation is fixed
  • Bug with AV on application closing when DLLs are used in the Trial edition is fixed
  • Bug with memory leaks on application finalization when Pooling is enabled is fixed
  • Bug on processing timestamp(6) field is fixed
  • Bug with cutting the STATUS field for SHOW ENGINE statement is fixed
  • Bug with AV failure when connection is not specified is fixed
  • Bug with batch operations is fixed

New in MySQL Data Access Components 8.7.22 25-Apr-16 (Jan 18, 2017)

  • RAD Studio 10.1 Berlin is supported
  • Lazarus 1.6 and FPC 3.0.0 is supported
  • Support for the BETWEEN statement in TDADataSet.Filter is added
  • Support for utf8mb4 charset is added
  • SmartFetch mode in Disconnected mode is supported
  • Bug with handling international characters in the VirtualTable component is fixed
  • Bug with displaying data in grid on error at applying cached updates is fixed
  • Bug in the SetOrderBy method in case when SQL contains ';' is fixed
  • Bug with using the LIKE clause in a dataset filter is fixed
  • Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
  • Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
  • Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
  • Bug with the 'Commands out of sync' error on reopening query is fixed
  • Bug with inserting international characters using batch is fixed
  • Bug with generating of UpdateSQL on using WITH clause is fixed
  • Data Type Mapping performance is improved

New in MySQL Data Access Components 8.6.20 14-Dec-15 (Jan 18, 2017)

  • Performance of TDALoader on loading data from TDataSet is improved
  • Several bugs in the SmartFetch mode are fixed
  • Bug with processing the cached data in the ApplyUpdates method is fixed
  • Bug with RecNo in the Unidirectional mode is fixed
  • Bug with storing some numbers with floating point is fixed
  • Bug with 'Thread Error' when connecting on OS X via HTTP tunnel is fixed

New in MySQL Data Access Components 8.6.19 18-Sep-15 (Jan 18, 2017)

  • Bug with showing values array for batch updates in SQLMonitor is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed

New in MySQL Data Access Components 8.6.18 09-Sep-15 (Jan 18, 2017)

  • RAD Studio 10 Seattle is supported
  • Now Trial for Win64 is a fully functional Professional Edition
  • INSERT, UPDATE and DELETE batch operations are supported
  • MariaDB Embedded is supported
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
  • Bug with endless reconnection in assigned connection is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed
  • SQLMonitor behavior on using similar objects is fixed
  • Bug with HTTP tunneling under UNIX is fixed

New in MySQL Data Access Components 8.5.27 (Dec 27, 2016)

  • Bug with adding Calculated fields after calling Prepare is fixed
  • Bug with executing batch updates and deletes on old versions of MySQL is fixed

New in MySQL Data Access Components 8.5.26 (Dec 27, 2016)

  • Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
  • Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
  • Bug with processing TIMESTAMP and DATETIME fields is fixed
  • Bug with loading data from a pipe is fixed
  • SSL support is fixed

New in MySQL Data Access Components 8.5.25 (Dec 27, 2016)

  • TDADataSetOptions.InsertAllSetFields property is added
  • Several bugs in SmartFetch Mode are fixed
  • Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
  • Bug with param values loss after changing TDAParam.ValueCount is fixed
  • Bug with PtrOffset function when Overflow Checking option enabled is fixed
  • Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
  • Bug with the duplicated MacroChar variable is fixed
  • Bug with RowsAffected calculation after executing the RefreshQuick method is fixed
  • Bug with processing MEDIUMTEXT fields when UseUnicode is True is fixed
  • Bug with processing DATETIME fields is fixed
  • Bug with processing TIMESTAMP(1)..TIMESTAMP(5) fields is fixed

New in MySQL Data Access Components 8.5.24 (Dec 27, 2016)

  • TVirtualDataSet component is added
  • Bug with assertion failure on editing data in SmartFetch mode is fixed
  • Bug with using parameters and column aliases in Master-Detail relation is fixed
  • Bug with AV on application closing when DLLs are used in the Trial edition is fixed
  • Bug with memory leaks on application finalization when Pooling is enabled is fixed
  • Bug on processing timestamp(6) field is fixed
  • Bug with cutting the STATUS field for SHOW ENGINE statement is fixed

New in MySQL Data Access Components 8.5.23 (Dec 27, 2016)

  • Bug with AV failure when connection is not specified is fixed
  • Bug with batch operations is fixed

New in MySQL Data Access Components 8.5.22 (Dec 27, 2016)

  • RAD Studio 10.1 Berlin is supported
  • Lazarus 1.6 and FPC 3.0.0 is supported
  • Support for the BETWEEN statement in TDADataSet.Filter is added
  • Support for utf8mb4 charset is added
  • SmartFetch mode in Disconnected mode is supported
  • Bug with handling international characters in the VirtualTable component is fixed
  • Bug with displaying data in grid on error at applying cached updates is fixed
  • Bug in the SetOrderBy method in case when SQL contains ';' is fixed
  • Bug with using the LIKE clause in a dataset filter is fixed
  • Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
  • Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
  • Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
  • Bug with the 'Commands out of sync' error on reopening query is fixed
  • Bug with inserting international characters using batch is fixed
  • Bug with generating of UpdateSQL on using WITH clause is fixed

New in MySQL Data Access Components 8.5.21 (Dec 27, 2016)

  • Data Type Mapping performance is improved

New in MySQL Data Access Components 8.5.20 (Dec 27, 2016)

  • Performance of TDALoader on loading data from TDataSet is improved
  • Several bugs in the SmartFetch mode are fixed
  • Bug with processing the cached data in the ApplyUpdates method is fixed
  • Bug with RecNo in the Unidirectional mode is fixed
  • Bug with storing some numbers with floating point is fixed
  • Bug with 'Thread Error' when connecting on OS X via HTTP tunnel is fixed

New in MySQL Data Access Components 8.5.19 (Dec 27, 2016)

  • Bug with showing values array for batch updates in SQLMonitor is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed

New in MySQL Data Access Components 8.5.18 (Dec 27, 2016)

  • RAD Studio 10 Seattle is supported
  • Now Trial for Win64 is a fully functional Professional Edition
  • INSERT, UPDATE and DELETE batch operations are supported
  • MariaDB Embedded is supported
  • Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
  • Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
  • Bug with endless reconnection in assigned connection is fixed
  • Bug with editing Blob and Memo fields used in local filter is fixed
  • SQLMonitor behavior on using similar objects is fixed
  • Bug with HTTP tunneling under UNIX is fixed

New in MySQL Data Access Components 8.5.17 (Dec 27, 2016)

  • Critical bug with data encryption is fixed
  • Bug in IProviderSupport.PSExecuteStatement with parsing a SQL query is fixed
  • Bug with missing IdeVer.inc in Trial version is fixed

New in MySQL Data Access Components 8.5.16 (Dec 27, 2016)

  • Critical bug when parsing SQL query with parameters is fixed
  • Bug with the Refresh method in the SmartFetch mode is fixed
  • Bug with assertion failure in TMyBackup is fixed

New in MySQL Data Access Components 8.5.15 (Dec 27, 2016)

  • Now IsolationLevel is set on connection establishing
  • Bug with using bookmarks in a filtered dataset is fixed
  • Bug with restoring the original order of records after clearing IndexFieldNames is fixed
  • Bug with refreshing DbLookupComboBox of the detail dataset when Master-Detail relationship is used is fixed
  • Bug with SQL Monitor freezing when using in a DLL is fixed
  • Bug with calculation of TMyTable.RecordCount after executing the TMyTable.Refresh method when the TMyTable.Filter property is set is fixed
  • Bug with RefreshRecord when data type mapping is used is fixed
  • Bug with execution of script in Unicode or UTF8 coding is fixed
  • Bug in TMyDump when data type mapping is used is fixed

New in MySQL Data Access Components 8.5.14 (Apr 17, 2015)

  • RAD Studio XE8 is supported
  • AppMethod is supported
  • Bug with invalid names of Master-Detail parameters is fixed
  • Bug with the 'Cannot convert type' error in the TDADataSet.RefreshRecord method when data type mapping is used is fixed
  • Bug with AV failure in the SmartFetch mode is fixed
  • Bug with AV on calling GetVersion() in C++Builder is fixed
  • Bug with generating update SQL queries when table or field name is a keyword is fixed
  • Bug in TMyDump with bit and number fields backup is fixed
  • Bug in TMyDump with table backup when its name contains a dot character is fixed

New in MySQL Data Access Components 8.4.10 (Sep 18, 2014)

  • RAD Studio XE7 is supported
  • Lazarus 1.2.4 is supported
  • The TCustomDADataSet.GetKeyFieldNames method is added
  • The TCustomDAConnection.GetKeyFieldNames method is added
  • The ConstraintColumns metadata kind for the TMyMetaData component is added
  • Demo projects for FastReport 5 are added
  • Several bugs in the SmartFetch mode are fixed
  • Bug with quoting names in the EmptyTable method is fixed
  • Bug with calling the Refresh method after executing the EmptyTable method is fixed
  • Bug with setting calculated field values using the AsExtened property is fixed
  • Bug with re-calling the AfterExecute event is fixed
  • Bug with re-calling the BeforeExecute event is fixed

New in MySQL Data Access Components 8.3.9 (Sep 18, 2014)

  • The Command property is added to TMyConnection
  • The TMyTable.EmptyTable method is added
  • Support for the Upper and Lower statements in TDADataSet.Filter is added
  • Possibility to retrieve time values greater than 24:00:00 for a Time field is added
  • Bug with reopening TDADataSet after BreakExec is fixed
  • Several bugs in the SmartFetch mode are fixed
  • Bug with processing calculated and lookup fields in the SmartFetch mode is fixed
  • Bug with getting RecordCount when QueryRecordCount is True is fixed
  • Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
  • Bug with "Invalid field size" in TVirtualTable is fixed
  • Bug with AV failure on freeing objects on mobile platforms is fixed
  • Bug in TMyDump with data backup in the Unicode mode is fixed
  • Bug with AV failure in the design-time editor of the TMyTable component for Delphi 5 is fixed

New in MySQL Data Access Components 8.3.8 (Sep 18, 2014)

  • Bug with AV failure on fetching records in the UniDirectional mode is fixed
  • Bug with finding master parameters by original name on refreshing record when using master/detail relationship by parameters is fixed
  • Bug with compilation in C++Builder is fixed
  • Bug with setting boolean parameters in a non-English IDE at design-time is fixed

New in MySQL Data Access Components 8.3.7 (May 21, 2014)

  • RAD Studio XE6 is supported
  • Android in C++Builder XE6 is supported
  • Lazarus 1.2.2 and FPC 2.6.4 is supported
  • SmartFetch mode for TDataSet descendants is added
  • The TMyDataSetOptions.MasterFieldsNullable property is added
  • Now update queries inside TDataSet descendants have correct owner
  • The SetOrderBy method behavior is fixed
  • The GetOrderBy method behavior is fixed
  • Bug with displaying already installed DAC version in setup messages is fixed
  • Bug with the Filter behavior in the Metadata component is fixed
  • Bug with AV on modify table with one only Object field is fixed
  • Bug with Locate when a NULL value is present in the index field is fixed
  • Bug with IndexFieldNames when DataTypeMapping is enabled is fixed
  • Bug with freeing memory in the TDADataSet.Lookup method is fixed
  • Bug with SSL connection on Android is fixed
  • Bug with error processing on socket data reading under Unix is fixed
  • Bug with RefreshRecord when ReadOnly is set to True is fixed
  • Bug with SQL script parsing by TMyScript and TMyDump is fixed
  • Bug with connection establishing when Pooling is enabled is fixed

New in MySQL Data Access Components 8.2.6 (May 21, 2014)

  • Possibility to use MAS_ prefix for parameters when using master/detail relationship is added
  • Support for Autorefresh mode for Mac OS X, iOS and Android platforms is added
  • Bug with post data when LockMode=lmOptimistic and Data Type Mapping is applied is fixed
  • Bug with opening dataset when persistent fields were created in dataset is fixed
  • Bug with parameter name quoting on assigning field value to parameter is fixed
  • Bug with deleting a record inserted earlier in CachedUpdates mode is fixed
  • Bug on sorting BLOB fields is fixed
  • Bug with percentage count in the OnRestoreProgress event of the TDADump class is fixed
  • Bug with generating SQL queries by "SQL Generator" in design-time is fixed
  • Bug with field name quoting in TMyLoader is fixed
  • Bug in TMyDump with backup tables structure in MySQL 4.x is fixed

New in MySQL Data Access Components 8.2.5 (Feb 8, 2014)

  • 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
  • Compatibility of migrating floating-point fields from other components is improved
  • Bug with data loss when updating records in the CachedUpdates mode is fixed
  • Bug with connecting in the Direct mode under Windows 2000 and lower is fixed
  • Bug with RefreshRecord in the CachedUpdates mode is fixed
  • Bug with mapping single types to float types is fixed
  • Bug with mapping to BCD and FmtBCD types is fixed
  • Bug with data display in Detail Dataset when master field is Null is fixed
  • Bug with incorrect parameter sizes when re-opening a query is fixed
  • Bug with mapping to BCD fields when using TClientDataSet is fixed
  • Bug with filtering boolean fields is fixed
  • Bug with freeing complex fields after refreshing before editing is fixed
  • Bug with Locate by fields where Data Type Mapping is applied is fixed
  • Bug with RefreshQuick when IndexFieldNames is set is fixed
  • Bug with returning an incorrect value in the RowsAffected property is fixed
  • Bug with using the UnloadEmbLibraryOnDisconnect global variable is fixed
  • Bug with assigning embedded parameters is fixed
  • Bug with GetTableNames is fixed

New in MySQL Data Access Components 8.1.4 (Feb 8, 2014)

  • Critical bug with parsing unicode SQL queries is fixed

New in MySQL Data Access Components 8.1.3 (Feb 8, 2014)

  • RAD Studio XE5 is supported
  • Application development for Android is supported
  • Lazarus 1.0.12 is supported
  • IPv6 protocol support is added
  • MariaDB is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • Flexible management of conditions in the WHERE clause 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
  • The AllowImplicitConnect option for the TMyConnection component is added
  • The SQLRecCount property for the TMyQuery and TMyStoredProc components is added
  • The ScanParams property for the TMyScript component is added
  • The RowsAffected property for the TMyScript component is added
  • ConnectionTimeout is now used when disconnecting after connection loss
  • Bug in TDALoader with data loading from Dataset when the FetchAll option is set to False is fixed
  • Bug with TDALoader.LoadFromDataSet is fixed
  • Bug with storing the dbMonitor active state to DFM is fixed
  • Bug with setting ConnectionTimeout for Unix, Mac OS and iOS platforms is fixed
  • Bug with incorrect displaying of long names of parameters and macros in design-time is fixed
  • Bug with processing cached data when UpdateRecordTypes is not default is fixed
  • Bug with moving data from WideMemo to String fields by TCRBatchMove is fixed
  • Bug in TCRBatchMove when destination dataset has no key fields is fixed
  • Bug with TCRBatchMove and DataSets in the UniDirectional mode is fixed
  • Bug with showing a connection dialog in design-time when LoginPrompt is set to False is fixed
  • Bug with setting the connection string containing inline comments is fixed
  • Bug with unnecessary unlock calling after an update error is fixed
  • Bug in TMyScript with script parsing is fixed
  • Bug with AssignConnect from a disconnected source connection is fixed
  • Bug with processing large FmtBCD fields is fixed
  • Bug with opening a table with timestamp fields when Charset is set to 'UTF8' is fixed

New in MySQL Data Access Components 8.1 (Oct 10, 2013)

  • RAD Studio XE5 is supported
  • Application development for Android is supported
  • Lazarus 1.0.12 is supported
  • IPv6 protocol support is added
  • MariaDB is supported
  • Performance is improved
  • Automatic checking for new versions is added
  • The possibility to use conditions 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
  • The AllowImplicitConnect option for the TMyConnection component is added
  • The SQLRecCount property for the TMyQuery and TMyStoredProc components is added
  • The ScanParams property for the TMyScript component is added
  • The RowsAffected property for the TMyScript component is added
  • ConnectionTimeout is now used when disconnecting after connection loss

New in MySQL Data Access Components 8.0 (May 15, 2013)

  • Rad Studio XE4 is supported
  • NEXTGEN compiler is supported
  • Application development for iOS is supported
  • FPC 2.6.2 and Lazarus 1.0.8 are supported
  • Connection string support is added
  • Possibility to encrypt entire tables and datasets is added
  • Possibility to determine if data in a field is encrypted is added
  • Support for TimeStamp, Single and Extended fields in VirtualTable is added

New in MySQL Data Access Components 7.6.12 (Apr 14, 2013)

  • Rad Studio XE3 Update 2 is now required
  • Bug with AV on adding TFieldDef items to FieldDefs for Delphi 2009 and higher is fixed
  • Bug with incorrect detection of the numeric parameter type in ExecSQL is fixed
  • Bug with assigning data to blob fields when using Data Type Mapping is fixed
  • Bug with inserting a new record into TStringGrid in FMX is fixed
  • Bug with unlocking a record after constraint violation is fixed
  • Bug with quoting index field names in TCRDBGrid is fixed
  • Bug with Master-Detail link by fields with non-English names is fixed
  • Bug with saving Date fields in XML is fixed
  • 'TableName cannot be empty' assertion on table opening is fixed
  • Bug with AV failure on filling default field values is fixed
  • 'Overflow check error' when using TMyDump is fixed
  • Bug with dumping of binary data types when TMyDumpOptions.FieldsAsString is True is fixed
  • Bug with using Unicode table and field names in TMyLoader is fixed
  • Bug with assertion failure on starting Lazarus is fixed

New in MySQL Data Access Components 7.5.9 (Oct 5, 2012)

  • Rad Studio XE3 is supported
  • Windows 8 is supported
  • Bug with storing empty MapRules collection in DFM is fixed
  • Bug with AV failure at freeing connection, for which AssignConnect was executed, is fixed

New in MySQL Data Access Components 7.2.8 (Jul 31, 2012)

  • Bug with Data Type Mapping and persistent fields is fixed
  • Bug with Data Type Mapping to Bytes and VarBytes is fixed
  • Bug with decryption of binary fields is fixed
  • Bug with editing calculated fields is fixed
  • Connection dialog is now open in the screen center instead of the desktop center
  • Several bugs with compilation on Delphi XE2 from Source code are fixed
  • ConnectionTimeout is now used when connecting to an inaccessible server
  • Bug with compilation for iOS is fixed
  • Bug with AV failure when processing a prepared query at connection loss is fixed
  • Bug with processing Blob fields in C++Builder 5 is fixed

New in MySQL Data Access Components 7.2.7 (Jun 28, 2012)

  • Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
  • Data Type Mapping support is added
  • Data encryption in a client application is added
  • The TMyEncryptor component for data encryption is added
  • Calling of the TCustomDASQL.BeforeExecute event is added

New in MySQL Data Access Components 7.1.4 (Jan 24, 2012)

  • The UniqueFieldIndexSeparator global variable is added
  • Improved performance of HTTP tunneling
  • Bug with assertion failure at proccesing the cached data is fixed
  • Bug with Delphi IDE hanging at closing in case of using DBMonitor is fixed
  • Bug with freeing memory in Lazarus is fixed
  • Bug with executing the queries with parameters in Delphi 5 is fixed
  • Several bugs with 64-bit application development are fixed
  • Several bugs in design-time editors are fixed

New in MySQL Data Access Components 7.1.3 (Jan 24, 2012)

  • Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
  • Mac OS X and iOS in RAD Studio XE2 is supported
  • FireMonkey support is improved
  • Lazarus 0.9.30.2 and FPC 2.4.4 are supported
  • Mac OS X in Lazarus is supported
  • Linux x64 in Lazarus is supported
  • FreeBSD in Lazarus is supported
  • Performance of SQL query generation for stored procedure execution is improved
  • Bug with deleting record in FetchAll = False mode when LockMode is lmPessimistic is fixed
  • Bug with memory leak in TDALoader is fixed
  • Problem with receiving DateTime parameter for DBMonitor in Delphi 2009 and higher is fixed

New in MySQL Data Access Components 7.0.2 (Nov 7, 2011)

  • Bug with compilation for Linux in Lazarus is fixed
  • Bug with the QueryRecCount option queries containing the 'DISTINT' and 'AS' clauses is fixed
  • Bug in TMyLoader with processing field names with spaces is fixed
  • Bug with setting the TMyTable.Limit property when the ORDER BY clause is set is fixed

New in MySQL Data Access Components 7.0.1 (Nov 7, 2011)

  • Embarcadero RAD Studio XE2 is supported
  • Application development for 64-bit Windows is supported
  • FireMonkey application development platform is supported
  • Support of master/detail relationship for TVirtualTable is added
  • OnProgress event in TVirtualTable is added
  • TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string is added
  • Bug with refreshing record when using master/detail relationship is fixed
  • Bug with detection of original field name for query with aliases is fixed
  • Bug with AV failure on droping down tables list of TMyTable in design time when DisconnectedMode = True is fixed

New in MySQL Data Access Components 6.10.0.9 (Nov 7, 2011)

  • Bug with assertion failure on using master/detail relationship with TClientDataset is fixed
  • Bug in TCustomDADataSet.PSGetKeyFields method when in dataset persistent fields was created is fixed
  • Bug in TMyDump with restore BLOB data is fixed

New in MySQL Data Access Components 6.10.0.8 (Nov 7, 2011)

  • Possibility to load data in TVirtualTable without recreating persistent fields is added
  • Working in design time editor of the TVirtualTable component is improved
  • Loading files opened by other applications is improved
  • Bug with processing key fields on record posting is fixed
  • Several bugs with design-time editors for Lazarus are fixed
  • Bug with processing OUT parameters is fixed
  • Bug with executing script in TMyScript when delimiter "$$" is used is fixed
  • Bug with processing shared-memory-base-name for the mpMemory protocol is fixed

New in MySQL Data Access Components 6.10.0.7 (Nov 7, 2011)

  • Bug with the "BAD HANDSHAKE" error on connecting to some versions of MySQL is fixed

New in MySQL Data Access Components 6.10.0.6 (Nov 7, 2011)

  • Lazarus 0.9.30 and FPC 2.4.2 is supported
  • Now the BreakExec method also stops working when getting record count if QueryRecCount=True
  • Bug in bookmark validity check is fixed

New in MySQL Data Access Components 6.00.0.5 (Nov 7, 2011)

  • Delphi & C++Builder XE Starter Edition supported
  • Fixed registration procedure of Borland SQL Monitor when TMySQLMonitor is created at runtime
  • Fixed bug with executing script in TMyScript when delimiter "$$" is used
  • Fixed bug in TMyDump with backing up and restoring data in Unicode mode

New in MySQL Data Access Components 6.00.0.4 (Feb 2, 2011)

  • Embarcadero RAD Studio XE supported

New in MySQL Data Access Components 5.90.0.54 (Dec 8, 2009)

  • Added support for dbMonitor 3
  • Added TMyConnection.HttpOptions that contains settings for HTTP connection
  • Fixed bug with updating table, that has field name, representing a valid hexadecimal number
  • Fixed bug with updating field value with preceding spaces when TrimFixedChar or TrimVarChar = True
  • Fixed bug with executing large file in UTF-8 format
  • Fixed bug with setting Field.Origin

New in MySQL Data Access Components 5.90.0.53 (Dec 8, 2009)

  • Now Required flag is set for UpdatingTable fields only
  • Now Field.Origin concatenates table alias (instead of table name) with field name
  • Fixed bug with detecting parameter size for MBCS strings
  • Fixed problem with detecting slash with text after it as a delimiter in TDAScript
  • Fixed bug with SetOrderBy and SetWhere when there is no space before ORDER or WHERE
  • Fixed bug with executing large file in Unicode format
  • Fixed bug with backuping of the TINYINT(1) fields

New in MySQL Data Access Components 5.90.0.52 (Dec 8, 2009)

  • Added TMyDataSetOptions.TrimVarChar option
  • Added TMyDump.Options.InsertType property
  • Now the AssignConnect method copies transaction state
  • Now schema name is used when filling default values if DefaultValues = True
  • Fixed problem with help registration under RAD Studio 2010
  • Fixed problem with loading DataSet Manager under RAD Studio 2010
  • Fixed bug with locating records using the LocateEx method and the lxNearest option
  • Fixed bug with SQL Generator in design-time
  • Fixed bug with AV failure in MemData

New in MySQL Data Access Components 5.90.0.51 (Sep 30, 2009)

  • Embarcadero RAD Studio 2010 suppored

New in MySQL Data Access Components 5.80.0.47 (Jun 23, 2009)

  • Added the Disconnected property to TCustomDADataSet
  • Added support for TQuery.DataSource property in BDE Migration Wizard
  • Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
  • Added support for NUMERIC parameters in TMyStoredProc
  • Improved work of TMyDump - backup tables before backup views
  • Fixed bug with the GotoCurrent method
  • Fixed bug with LocalMasterDetail and Prepare method
  • Fixed bug with FullRefresh and macros
  • Fixed bug with output UTF8 symbols in log of Embedded server for Delphi 2009

New in MySQL Data Access Components 5.80 (Apr 8, 2009)

  • Free Pascal under Linux supported
  • Added NoPreconnect property to TMyScript for executing CONNECT and CREATE DATABASE commands

New in MySQL Data Access Components 5.70 (Nov 11, 2008)

  • Delphi 2009 and C++Builder 2009 supported
  • Extended Unicode support for Delphi 2007 added (special Unicode build)
  • Free Pascal 2.2 supported
  • Powerful design-time editors implemented in Lazarus
  • Completed with more comprehensive structured Help

New in MySQL Data Access Components 5.55 (Aug 22, 2008)

  • dbForge Fusion for MySQL support added

New in MySQL Data Access Components 5.20 (Nov 15, 2007)

  • CodeGear RAD Studio 2007 supported
  • Added the OnProgress event in TMyLoader
  • Added an option to include the field list in INSERT queries generated by TMyDump
  • Added ability to send the DataSetChange event after dataset open

New in MySQL Data Access Components 5.00 (Apr 19, 2007)

  • Disconnected model, Local Failover, added DataSet manager, supported integration with MySQL Developer Tools, added data export/import to/from xml, extended MySQL functionality support, lots of enhancements to existing functionality, support for CodeGear Delphi 2007 for Win32