MySQL Data Access Components Revision History

14.0.1 15-Jun-26

Fixed a bug that caused the ReceiveHeader: Net packets out of order error when wait_timeout expired
Fixed a bug in TMyScript script execution when the default delimiter (;) was used and the script contained the DELIMITER ;; statement

14.0.0 27-Mar-26

Added support for RAD Studio 13 Florence Release 1
Added support for the Arm64EC target platform
Added support for Lazarus 4.6
Added support for MySQL 9.6
Added the SetFieldsReadOnly property to TCustomMyDumpProcessor to allow adding read-only fields in INSERT statements during backup
Added the Delimiter property to TCustomMyDumpProcessor to set a custom delimiter for stored procedure and trigger backup
Added the "For the current user/For all users" option during installation
Added masking of the Password property in the Connection component to prevent it from being stored in memory as plain text
Added the GetWhere method to the TCustomDADataSet component
Added the DeleteOrderBy method to the TCustomDADataSet component
Added the RangeFieldCount property to TCustomDADataSet to specify the number of indexed fields used for range setting
Added the AutoClose option to TCustomDADataSet to control automatic closing of a dataset when its associated ClientDataSet is closed
Renamed the DecimalsCount property of TMyFloatVector to Scale
Fixed an issue in tunnel.php that required establishing a tunnel connection in a browser first
Fixed an issue with executing SHOW COLUMNS for MySQL 4.11.x when UseUnicode = True
Fixed an issue that caused incorrect record sorting in a dataset when both ORDER BY and IndexFieldNames are used
Fixed an issue with the ConnectString property in the Connection component when its value contained a sequence of SQL comment characters

13.0.1 26-Dec-25

Added support for Lazarus 4.4
Added the DistinctParams property for the DataSet component to prevent duplicate parameters with the same name
Extended support for the Connection component's AllowImplicitConnect property to the Script and SQL components
Fixed an AV failure that could occur when reading a persistent TWideStringField in Delphi 7
Fixed an issue where XML fields could be saved incorrectly when using the dataset component's SaveToXML method
Fixed an issue with registering help files in RAD Studio 13
Fixed an access violation that could occur when reopening the master table with LocalMasterDetail set to True
Fixed a possible nil reference to Encoding in the TParser constructor

13.0.0 17-Sep-25

Added support for RAD Studio 13 Florence
Added support for Lazarus 4.2
Added support for MariaDB 12
Added extended support for the Vector data type
Added support for the UUID data type in MariaDB 10.7 and later
Added support for the INET4 and INET6 data types in MariaDB 10.10 and later
Added support for Bearer Token authentication when connecting through HTTP tunnel
Added the InsertBatchSize option for the TMyDump component to be able to set the size of the SQLInsert query
Added the AnsiQuotesMode option to set the ANSI_QUOTES value for the sql_mode variable
Added support for system proxy settings to the TProxyOptions class for HTTP tunnelling
Added the Pooled function to the TCustomDAConnection component
Added support for ReportBuilder 23 in the Demo project
Improved trigger backup with TMyDump
Fixed a bug with double-quoting of the database name when performing a backup with TMyDump
Resolved an issue with TMyDump that occurred when a database name contained reserved words
Resolved an issue where connecting to MySQL 4.0 or earlier caused the "sql_mode is not supported in MySQL versions 4.0 and earlier" error
Resolved an issue where all connections were removed from the pool if TPoolingOptions.MinPoolSize was set to a value greater than 0
Resolved an issue where getting the record count failed if the query contained an ORDER BY clause
Resolved an issue with C++Builder compilation
Resolved an issue that caused a memory leak in the GetIPInterfaces procedure
Fixed paths in *.dproj files for IOHandlers and updated the documentation

12.4.1 07-Jul-25

Added support for Lazarus 4.0
Resolved an issue with declaring the TValueArr data type in C++ Builder
Fixed a bug where setting SQL in the Query component changed the case of a parameter name
Fixed a bug that occurred when calling the FindKey method on a cloned dataset
Fixed a bug that occurred when reserved words were used as field names in filters

12.4.0 20-Mar-25

Added support for RAD Studio 12 Athens Release 3
Added support for the RAD Studio 64-bit IDE
Added support for Lazarus 3.8
Added support for MySQL 9
Added support for parameters in the Script component
Added support for the TurboPack SynEdit package in component editors
Added support for syntax highlighting in component editors in Lazarus on the Windows platform
Added the IndentFormat argument to the SaveToXML method of the dataset to decrease file size
Added the SaveToJSON method for serializing a dataset to the JSON format
Added the ability to use readonly fields in the SQL Generator at design-time
Added support for password-protected private key for SSL protocol
Added the EMySqlNetException class for internal errors in the MySQL protocol
Improved work with design-time editors in the High DPI mode
Fixed a bug with ambiguity between the CRJSON.TJSONObject and System.Json.TJSONObject classes
Fixed a bug with unloading OpenSSL libraries when connection pooling is used

12.3.2 20-Jan-25

Moved the CRFunctions.CRTimeZoneInformation global variable to the interface section
Fixed a bug causing an assertion failure when using the TCRSSHIOHandler component with FetchAll set to False
Fixed an issue with handling stored procedures when SELECT privileges were not granted
Fixed an issue with the SaveToXML method of the TMemDataSet class and its descendants, which occurred when saving UUID fields
Fixed a bug that occurred when calling the RefreshRecord method with FullRefresh set to True
Fixed an issue with processing the Filter property of a dataset that occurred when it included the NOT operation
Fixed an issue with using subfunctions in a filter

12.3.1 24-Oct-24

Restored support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.6

12.3.0 27-Sep-24

Added support for RAD Studio 12 Athens Release 2
Added support for C++Builder 64-bit Windows (Modern) Application Development
Added support for Lazarus 3.4
Added C++Builder demo components for working with SecureBridge
Added demo with the new version of SecureBridge components
Added the WriteBOM property for TMyDumpOptions
Fixed bug with AV on closing application when Pooling=True in MySQL Embedded
Fixed bug with incorrect behavior of TCRSSLIOHandler.IsSecure when FetchAl = False

12.2.1 01-May-24

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

12.2.0 24-Apr-24

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

12.1.0 19-Feb-24

Added support for Lazarus 3.0
Fixed bug with getting warning message of using bmBinary mode
Fixed bug with assertion failure or AV in batch operation

12.0.0 15-Nov-23

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

11.3.0 17-Mar-23

Added support for RAD Studio 11 Alexandria Release 3
Added support for iOS Simulator ARM 64-bit 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

11.2.0 12-Sep-22

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

11.1.1 12-Apr-22

RAD Studio 11 Alexandria Release 1 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

11.0.2 09-Dec-21

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

11.0.1 13-Sep-21

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

10.4.4 14-Jul-21

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

10.4.3 06-Apr-21

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

10.4.2 26-Mar-21

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

10.4.1 02-Mar-21

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

10.3.2 14-Sep-20

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

10.3.1 26-Aug-20

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

10.2.4 01-Jun-20

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

10.1.3 10-Mar-20

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

10.1.2 26-Nov-19

Android 64-bit is supported
Lazarus 2.0.6 is supported
OpenSSL 1.1 library is supported
Now Trial edition for macOS and Linux is fully functional
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

10.0.1 22-Jul-19

macOS 64-bit is supported
Release 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

9.4.10 24-Jun-19

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

9.3.9 21-Jan-19

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

9.3.8 26-Nov-18

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

9.2.7 17-Sep-18

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

9.2.6 09-Jul-18

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

9.1.5 02-Apr-18

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

9.1.4 18-Jan-18

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

9.1.3 19-Sep-17

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

9.0.2 15-May-17

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

9.0.1 05-Apr-17

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

8.7.27 21-Nov-16

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

8.7.26 01-Nov-16

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

8.7.25 08-Sep-16

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

8.7.24 27-Jun-16

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

8.7.23 28-Apr-16

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

8.7.22 25-Apr-16

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

8.6.21 01-Feb-16

Data Type Mapping performance is improved

8.6.20 14-Dec-15

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

8.6.19 18-Sep-15

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

8.6.18 09-Sep-15

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

8.5.17 14-Jul-15

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

8.5.16 30-Jun-15

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

8.5.15 17-Jun-15

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

8.5.14 14-Apr-15

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

8.4.13 14-Jan-15

Lazarus 1.2.6 is supported
Support for fraction seconds of datatime fields is added
The TMyDataSetOptions.SaveBlobsAsHex property is added
Getting datetime precision of table columns via TMyMetaData for MySQL server 5.6 and higher is added
Performance of backup data using TMyDump is improved
Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
Bug with losing data after VirtualTable closing on SaveToStream is fixed
Bug with RestoreUpdates in CachedUpdates mode is fixed
Bug with processing FarEast symbols in WideString fields is fixed
Bug in TMyLoader with loading Extended fields is fixed
Bug in TMyDump with backup Unicode text fields is fixed
Bug on using the AssignConnect method in Dll is fixed

8.4.12 25-Nov-14

Bug when using table aliases in the DetailFields name is fixed
Bug with using UPPER and LOWER functions in filter is fixed
Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
Bug with TCustomDADataSet.FindKey is fixed
Bug with editing DateTime fields when data type mapping from string to DateTime is used is fixed
Bug with refreshing record if the key field has the TSQLTimeStamp data type is fixed
Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
Bug with 'Thread Error' when connecting on OS X is fixed
Bug with setting time values greater than 24:00:00 for Time fields is fixed
Bug with processing Result parameters in TMyStoredProc is fixed

8.4.11 29-Sep-14

ConnectionTimeout is now used on OSX and Mobile platforms
Bug with RecNo in the UniDirectional mode is fixed
Bug with setting SQL query when ParamCheck = False is fixed
Bug with AV failure on getting metadata by TCustomDADataSet is fixed
Bug with AV failure under Mobile when DacFMX is used is fixed

8.4.10 15-Sep-14

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

8.3.9 31-Jul-14

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

8.3.8 27-May-14

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

8.3.7 29-Apr-14

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

8.2.6 19-Feb-14

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

8.2.5 25-Dec-13

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

8.1.4 23-Sep-13

Critical bug with parsing unicode SQL queries is fixed

8.1.3 18-Sep-13

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

8.0.2 15-Jul-13

Connection dialog is improved
Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
Bug in the alerter when DisconnectedMode is set to True for a connection is fixed
Bug with the connection OnLogin event is fixed
Bug with incorrect counting of connections in pool is fixed
Bug with time fields in Lazarus is fixed
Bug with varbinary fields in Lazarus is fixed
Bug with using case-insensitive filter is fixed
Bug with getting and setting the SQL property of FastReport datasets is fixed
Bug with positioning of Fields Editor is fixed
Bug with not using index fields on locating records is fixed
Bug with processing the cached data when UpdateRecordTypes is not default is fixed
Bug with processing persistent fields in TVirtualTable is fixed
Bug with data type mapping of BLOB fields is fixed

8.0.1 25-Apr-13

Rad Studio XE4 is supported
NEXTGEN compiler is supported
Application development for iOS is 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 of TimeStamp, Single and Extended fields in VirtualTable is added
Bug with Master-Detail for TClientDataSet in Rad Studio XE3 is fixed
Bug with Master-Detail by non-English fields is fixed
Bug with IndexFieldNames by non-English fields is fixed
Bug with incorrect RecordCount result when a query contains both ORDER BY and LIMIT is fixed
Bug with calling Cancel in the BeforePost event is fixed
Bug when setting the TDataSet.Filter property for empty dataset is fixed
Bug with incorrect TVirtualTable version displaying in the About box is fixed
Thread handle leak when using pooling is fixed
SSL support in Mac OS is fixed
Bug with script execution in TMyScript when using not a default delimiter is fixed
Bug with memory leak when RefreshOptions.roBeforeEdit is set is fixed
Bug with TMyLoader.LoadFromDataSet when UniDirectional = True and FetchRows = 1 is fixed
Now the TCustomDASQLMonitor.Options.moDBMonitor property is set to False by default

7.6.12 14-Feb-13

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

7.6.11 12-Dec-12

Rad Studio XE3 Update 1 is now required
C++Builder 64-bit for Windows is supported
TMyDumpOptions.FieldsAsString property for dumping all data types as string is added
Bug with using quoted field names in the IndexFieldNames property is fixed
Bug in TMyStoredProc with closing dataset when the Disconnected property is True is fixed
Bug with processing macros named in Cyrillic is fixed
Bug with getting default values for fields with aliases is fixed
Bug in TMyDump with dump BIGINT UNSIGNED fields is fixed
Bug with resolving hostname on iOS device is fixed
Bug with compatibility with ODAC is fixed

7.5.10 07-Nov-12

Some improvements for NEXTGEN support are added
Integration with dbForge Studio for MySQL is added
Support for ftGraphic and ftFmtMemo parameter data types is added
Informativity of messages about errors in connection is improved
Dependency of design-time packages on FMX packages is removed
TMyConnectionOptions.Interactive property for interactive connections support is added
Support for binary parameters of stored procedures is added
Support for MySQL Embedded is added to FastReport components
Performance of backing up process using TMyDump in case when TableNames is specified is improved
Bug with data loss in pessimistic lock mode is fixed
Bug with AV failure in RefreshQuick method is fixed
Bug with renaming of fields with the same names is fixed
Bug with dependency parameters count in macros on delimeter is fixed
Bug with storing the LoginPrompt connection property is fixed
Bug with dump data from VIEW is fixed
Bug with creating columns on setting the TableName property in TDALoader is fixed
Bug with TMyDump.BackupQuery repeated call is fixed

7.5.9 05-Sep-12

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

7.2.8 24-Jul-12

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

7.2.7 21-Jun-12

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
Bug with executing a script that ends with a commented line is fixed
Bug with assigning outsize data to TWideStringField is fixed
Bug with AV failure at calling the SetRecNo method when using local sorting is fixed
Bug in design time editor of the TVirtualTable component with master-detail relationship is fixed
Bug with creating SQL query for stored procedure executing for MySQL Embedded server is fixed
Bug with assertion failure on stored procedure executing when its name contains the '$' symbol is fixed
Bug with executing SQL script that contrains the DELIMITER key word is fixed
Bug with AV failure at executing AssignConnect is fixed
Bug in design time editor of the TMyStoredProc component is fixed

7.1.6 02-Apr-12

Lazarus 0.9.30.4 and FPC 2.6.0 are supported
Bug with SQL Generator in the design-time is fixed
Bug with generating Update SQL with fields that have aliases is fixed
Bug with saving BCD fields from TVirtualTable to a Stream is fixed
Bug with LocalMasterDetail is fixed

7.1.5 01-Mar-12

Update 4 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Bug with AV failure at executing ApplyUpdates is fixed
Bug with hanging RAD Studio XE2 when opening ConnectDialog is fixed
Several bugs in design-time editors are fixed
Bug with processing some queries on executing TFieldDefs.Update is fixed
Bug in TMyLoader with loading data in a temporary table is fixed

7.1.4 28-Dec-11

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

7.1.3 23-Nov-11

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

7.0.2 10-Oct-11

Bug with compilation for Linux in Lazarus is fixed
Bug with the QueryRecCount option queries containing the 'DISTINCT' 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

7.0.1 15-Sep-11

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

6.10.0.9 19-Jul-11

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

6.10.0.8 15-Jun-11

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

6.10.0.7 12-May-11

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

6.10.0.6 28-Apr-11

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

6.00.0.5 10-Mar-11

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

6.00.0.4 26-Jan-11

Added the UnloadEmbLibraryOnDisconnect variable for unloading MySQL Embedded server library on connection disconnect
Now on backing up data in TMyDump the SQL_MODE option is set to NO_AUTO_VALUE_ON_ZERO
Fixed bug in TMyDump with backup BLOB fields when UseUnicode is True
Fixed bug with RefreshQuick for table with several timestamp fields
Fixed bug with processing parameters when charset is 'gbk'
Fixed bug with getting the field default values for MySQL server version 4.x
Fixed several bugs when LocalFailover and Pooling are set to True

6.00.0.3 08-Dec-10

Added calling the BeforeExecute event for the Open and Refresh dataset operations
Fixed bug in the Refresh method when connection is lost
Fixed bug with refreshing record for Master-Detail datasets
Fixed bug in TMyDump with quoting of fields names on backup data
Fixed bug in TMyDump with backup data in Unicode mode
Fixed bug with starting transaction on MySQL 3.x

6.00.0.2 04-Nov-10

Added checking that dataset is open on calling the TDataSet.Locate method
Fixed bug with decoding data on loading XML
Fixed bug in Migration Wizard with adding unnecessary spaces

6.00.0.1 13-Sep-10

Embarcadero RAD Studio XE suppored
Fixed bug with the LIKE keyword in the TDataSet.Filter property
Fixed bug with filling default expression for fields in the design mode for inactive dataset

5.90.0.60 13-Aug-10

Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
Added the OnBeforeExecute event
Added ability to set shared-memory-base-name for the mpMemory protocol
Fixed bug in Migration Wizard with converting units in the UTF8 and UTF16 encoding
Fixed bug with RefreshRecord and numbers with floating point
Fixed bug with AV failure in TMyScript
Fixed bug with dumping BLOB fields when UseUnicode is True
Fixed bug with processing string fields when East code page is used

5.90.0.59 24-Jun-10

Added ability to lock records in the CachedUpdate mode
Added overloaded declaration of the ApplyUpdates method to choose update kind
Fixed bug with quote that first character inside quoted string for the Filter property
Fixed bug in TCRBatchMove with processing RecordCount
Fixed bug with writing prepared BLOB fields
Fixed bug with processing stored procedures with N(VAR)CHAR parameters types
Fixed bug with dumping string fields when East code page used

5.90.0.58 26-May-10

Fixed bug with HTTP tunneling
Fixed bug with infinite reconnect when LocalFailover is set to True
Fixed bug with fields length for SHOW statements for Delphi 5

5.90.0.57 09-Apr-10

Fixed bug with comparing Date field values on optimistic locking
Fixed bug in the AddWhere, DeleteWhere, SetOrderBy, and GetOrderBy methods for Tables
Fixed bug with calculating RecNo in CachedUpdates mode
Fixed bug with TMyBackup

5.90.0.56 04-Mar-10

Added ability to send call stack information to dbMonitor component
Fixed bug with refreshing record when using master/detail relationship
Fixed bug with LocalUpdate in the CachedUpdates mode
Fixed bug with DBMonitor for C++ Builder 6
Fixed bug with processing transaction when connection is lost

5.90.0.55 26-Jan-10

Added OnStart, OnCommit, OnRollback events to TDATransaction
Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmPessimistic
Fixed problem with using TLargeintField in master/detail
Fixed bug with processing transaction when connection is lost
Fixed bug with establishing connection with HTTP tunneling

5.90.0.54 01-Dec-09

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

5.90.0.53 12-Nov-09

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

5.90.0.52 13-Oct-09

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

5.90.0.51 10-Sep-09

Embarcadero RAD Studio 2010 suppored
Now the subdetail is refreshed before the AfterRefresh event of the detail is called
ConnectionTimeout is now used when resolving the host name
Fixed bug with the OpenNext method
Fixed bug in the RefreshQuick method when using master/detail relationship
Fixed bug with quoting of fields containing the dot(.) char in the name

5.80.0.50 01-Sep-09

Added the TCustomMyConnection.GetTriggerNames method
Added the TMyDump.Options.CommitBatchSize property
Added ability to backup triggers without backuping table structure in TMyDump
Now the value from the master dataset has priority over the DefaultExpression value
Fixed bug with parsing TDAScript.Statements
Fixed bug with RefreshQuick for query with fields that have similar names in several tables
Fixed bug with not unlocking record in the CachedUpdates mode if no fields were changed
Fixed bug with backup users in TMyDump

5.80.0.48 24-Jun-09

Added ability to backup triggers in TMyDump
Added the TMyConnection.Options.NullForZeroDelphiDate property to hide the "30-12-1899" dates
Fixed bug with local sorting in CachedUpdates mode
Fixed bug with raising exceptions on locating records when IndexFieldNames is set
Fixed bug with calculating connection count in Disconnected mode
Fixed bug with calling the OnError event on connection failure when Pooling is enabled
Fixed bug with macros in TDAScript
Fixed bug with setting default values when the JOIN statement is used
Avoided bug of some versions of MySQL with fields length for SHOW SLAVE STATUS statement

5.80.0.47 27-May-09

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

5.80.0.46 02-Apr-09

Added support for Free Pascal under Linux
Added NoPreconnect property to TMyScript for executing CONNECT and CREATE DATABASE commands
Fixed bug with DetailDelay and refreshing closed dataset
Fixed bug with not calling UnregisterClient for internal command of dataset
Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate
Fixed bug with detecting DBMonitor on 64-bit Windows
Fixed bug with processing parameters when using East Asian languages
Fixed bug with executing ApplyUpdates when LockMode = lmOptimistic in the CachedUpdates mode

5.70.0.45 26-Feb-09

Added ability to backup user defined query to file or stream in TMyDump
Fixed bug with not working CachedUpdates in TVirtualTable
Fixed bug with suppressing errors in TVirtualTable.LoadFromFile
Fixed problem with restoring current row after refresh
Fixed bug when statements, executed on TClientDataSet.ApplyUpdates, were not shown in DBMonitor
Fixed access violation on the TClientDataSet.ApplyUpdates call
Fixed bug in the RefreshQuick method with SQL query joining several tables
Fixed bug in TMyDump with backup stored procedure when its name must be quoted
Fixed bug with processing Boolean parameters for some versions of MySQL
Fixed bug with processing Time parameters
Bug in Delphi 2006 and above with the BcdCompare function avoided

5.70.0.44 05-Jan-09

Fixed bug with treating some string elements as equal by CompareString
Fixed bug with processing Time fields on table locking

5.70.0.43 09-Dec-08

Fixed bug with calling stored procedures from MySQL server in the case sensitive mode

5.70.0.42 19-Nov-08

Added the TMyConnection.Options.CheckBackslashes property
Added calling the TfrxReport.OnBeforeConnect event when TfrxDACDatabase is connecting
Now timer in TCustomMyDataSet is created only when AutoRefresh is set to True
Fixed bug with processing DateTime fields on table locking
Fixed bug with specifying database name on setting Default values
Fixed bug with executing script in TMyScript when the "delimiter ;" statement is used
Fixed bug with processing binary and blob fields when the NoBackslashEscapes mode is used
Fixed bug with calling stored procedures when its name must be quoted
Fixed bug with field names containing '.'
Fixed bug with AV failure in TMyQuery.IsQuery
Fixed bug with name compatibility with ReportBuilder
Fixed bug with assertion failure on editing components in design time for Delphi 5
Fixed several bugs in DataSet Manager
Fixed bug in Migration Wizard with converting binary forms in Delphi 2009

5.70.0.41 23-Oct-08

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

5.55.0.39 22-Sep-08

Improved working with master/detail relationship when LocalMasterDetail=True
Fixed bug with AV on getting OldValue for BLOB fields
Fixed bug with processing BLOB fields when the NO_BACKSLASH_ESCAPES mode is used
Fixed Assert with executing StoredProcedure when exist param name equal to 'STATUS'
Avoided bug of some versions of MySQL with fields length for SHOW PROCESSLIST statement
Avoided bug of some versions of MySQL with fields length for SHOW SLAVE STATUS statement

5.55.0.37 21-Aug-08

dbForge Fusion for MySQL support added
Added support new DATE field type for MySQL server 5.0.54 and older
Added 'USE database' statement after database creating in TMyDump
Fixed bug with Master-Detail relationship and QuoteNames
Fixed bug with processing Blob parameters in TMyStoredProc
Fixed bug with starting transaction on MySQL 4.0 and lower
Avoided bug of MySQL server 5.0.51a with truncation values of SHOW PROCESSLIST

5.50.0.36 11-Jul-08

Added ability to recognize unquoted True/False values in DefaultExpression
Added support of NOT LIKE keyword in the TDataSet.Filter property
Improved working with master/detail on inserting new records
An event to handle exceptions on restoring added in TMyDump
Added support of Blob parameters in TMyStoredProc when UseUnicode is True
Fixed several bugs when working with inactive datasets
Fixed bug with filtering by TLargeIntField
Bug with autocommit after deleting records fixed
Fixing bug with calling the OnError event when LocalFailover is set to True
Fixed bug with displaying OUT parameters of stored procedures in DBMonitor
Fixed bug with NULL date in default values of DateTime fields
Fixed bug with determining primary key fields
Fixed bug with package names in FastReport 4.x for Delphi 2006
Added ability to call Code Editor from component editors

5.50.0.35 11-Jun-08

Fixed bug with the SetOrderBy method
Fixed bug with determining primary key fields
Fixed bug with generating update SQL with IS NULL in the WHERE clause at design-time
Fixed bug with AV failure on assigning the OnFilterRecord event handler
Fixed bug with multiple order fields in TMyTable
Fixed bug with output parameters in TMyStoredProc
Fixed bug with 'Invalid class typecast' error inside dlls

5.50.0.34 23-May-08

Added compatibility with UniDAC
The new component for metadata receiving added
Added ability to specify key fields for a dataset
Added support of automatic records locking
Added support for schema name in TMyStoredProc
Improved support of default field values
Improved work with master/detail
Fixed bug in TMyDump with backup data when database or table name must be quoted
Fixed bug with creating UpdateSQL queries when the WHERE clause is empty
Fixed bug with freezing when calling Lock for a locked table
Fixed bug with freezing when executing some SQL queries
Fixed bug with memory leaks on connection failure when Pooling is enabled
Fixed bug with calculating fields length for the SHOW CREATE TABLE statement
Avoided bug of MySQL 5.0.51 with fields length for SHOW ENGINES statement

5.20.1.15 04-Apr-08

Added support for Boolean parameters in TMyStoredProc
Fixed access violation on local sorting
Fixed bug with locating records using the LocateEx method and the lxNext option
Fixed bug with executing scripts from files larger than 2GB
Fixed bug with executing queries in DisconnectedMode
Fixed bug with executing prepared stored procedures
Fixed bug with calculating string fields length for queries containing string functions
Fixed bug with the QueryRecCount option queries containing the 'LIMIT' clause
Fixed bug in TMyDump with backup data without tables structure
Fixed bug in TMyDump with backup BLOB fields to hex
Fixed bug with processing Unicode in BLOBs

5.20.1.14 18-Feb-08

Enhanced local sorting with new options (DefaultSortType option, BIN sort type in IndexFieldNames)
Added support for SQLInsert, SQLUpdate, SQLDelete properties for updating with TDataSetProvider
Improved bookmarks comparison
Improved stability of the TMyEmbConnection component
Added TCustomMyConnectionOptions.OptimizedBigInt property to map LargeInt fields to Integer fields
Added TMyDataSetOptions.BinaryAsString property for processing Binary fields
Fixed bug with corrupting BLOB fields on CancelUpdates method call
Fixed bug with accessing persistent BLOB fields in closed dataset
Fixed bug with including fields from wrong table into update queries
Fixed bug with updating tables whose names contain special symbols like spaces
Fixed bug in TMyDump with backup data in Unicode mode
Fixed bug with fetching BLOB data when using MySQL client library
Fixed bug with memory leak in FetchAll=False mode
Fixed bug with case of table names in demo projects

5.20.0.13 09-Jan-08

Improved stability of the TMyEmbConnection component
Improved the BreakExec method to break data fetch
Fixed bug in master/detail for shifting columns count in the detail dataset
Fixed several bugs with records location
Bug with TCRBathMove which source dataset works in FetchAll=False fixed
Fixed several bugs with auto-generated update queries
Fixed bug with freezing when executing some stored procedures
Fixed design-time editors for Delphi 8
Fixed bug with QueryRecCount option for queries with the DISTINCT clause
Fixed bug with determining length for string fields returned by miscellaneous MySQL functions (INET_NTOA, etc.)
Avoided bug of MySQL 5.1 with field length for SHOW CREATE TABLE statement

5.20.0.12 14-Nov-07

Added support for TVariantField in VirtualTable
Optimized describing of stored procedure parameters
Added ability to upgrade MyDAC without uninstallation of previous MyDAC builds
Now an exception is raised when uaFail is assigned to UpdateAction in OnUpdateRecord event handler
Fixed bug with parsing numbers followed by parameters whose names consist of digits
Fixed bug with second script execution after the first execution failed with an exception
Fixed bug with locating variant values in TVirtualTable
Fixed bug with InsertID in the AfterExecute event
Fixed bug with executing scripts that contain BLOB values
Fixed bug with updating field definitions for queries that assign a variable value
Fixed bug with obtaining InsertId when the Assertions project option is disabled

5.20.0.11 27-Sep-07

CodeGear RAD Studio 2007 supported
Added the OnProgress event in TMyLoader
Improved color schema of syntax highlighting with SynEdit
Optimized memory utilization when loading XML files by the TVirtualTable.LoadFromFile method
Added an option to include the field list in INSERT queries generated by TMyDump
Now TMyConnection.GetTableNames returns an empty list when Database is not set
Added ability to send the DataSetChange event after dataset open
Fixed bug with using the Filter property for FindFirst and similar methods when Filtered is False
Fixed bug with calling First after changing UpdateRecordTypes in Edit mode
Fixed bug with Disconnected Model and Pooling
Fixed bug with committing updates in CachedUpdates mode
Fixed Assert with TCRBatchMove and BLOB fields
Avoided design-time bug with UniSynEdit
Bug with save/load data to/from XML fixed
Fixed bug with IDE startup failure
Fixed bug with locking records in detail datasets
Fixed bug with parameters and string constants in Unicode mode
Fixed bug with MySQL Developer Tools integration under Windows Vista
Fixed bug with the GetFieldEnum method and MySQL 4.1
Fixed bug with truncation results for the SHOW CREATE PROCEDURE command
Fixed bug with design-time editor of MyEmbConnection
Avoided MySQL bug with field length returned by the SHOW CREATE PROCEDURE statement

5.10.0.10 02-Aug-07

A runtime package for the TMySQLMonitor component added
Fixed bug with PSGetDefaultOrder method freezing for queries with complicated ORDER BY clauses
Fixed bug in TCRBatchMove with mapping fields by name when Fields count and FieldDefs count are not equal
Fixed bug with adding fields in TVirtualTable
Fixed bug with Pooling and Local Failover
Fixed bug with "Invalid Variant Type" exception under Windows 2000 when TDataSet.Refresh is called
Fixed bug with performance penalty when processing lookup and calculated fields
Problem with DBMonitor integration under Windows Vista Ultimate fixed
Bug with field names quotation in CRDBGrid fixed
Fixed bug with updating FieldDefs for some kind of composite queries
Fixed bug with editing datasets returned by TMyStoredProc
Fixed bug in TMyStoredProc with Local Failover and Disconnected Model
Fixed bug with updating server calculated fields in datasets
Fixed bug with performance loss when editing records containing BLOB and MEMO fields
Fixed bug in the Lock demo

5.10.0.9 12-Jun-07

C++Builder 2007 supported
Extended ability to detect MySQL boolean constants
Added ability to customize information view about fields in DataSetManager
Performance of some operations in DataSet Manager improved
The MySQLBuilder tool has been renamed to SQLBuilder for MySQL
Bug with the BaseSQL property set to an empty string after assigning macro values fixed
Bug with incorrect registry key used by connect dialog to save/load the Server value fixed
Bug with refreshing records in detail dataset fixed
Fixed bug with lookup and data fields with the same name
Fixed bug with calling the RefreshRecord method when the FullRefresh option is True
Fixed bug with raising exceptions when locating records on filtered recordsets
Minor bugs in DataSet Manager fixed
Avoided MySQL bug with truncating BLOB values affected by flow control constructs
Removed restriction on datasets that TMyDataSource can be associated with

5.00.1.7 16-May-07

Support for rmReconnectExecute failover action with SQL statements execution added
Added ability to drag datasets between connections in group by connections mode in DataSet Manager
Added ability to assign DataSource and DataField properties of DevExpress DB-aware controls automatically in DataSet Manager
Extended abilities of assigning default controls for datasets and fields in DataSet Manager
Fixed bug with "DisposeBuf failed" exception on updating string fields in CachedUpdates mode
Fixed bug with AV failure after second call to CommitUpdates when there are skipped records in cache
Bug with complex fields modification in Disconnected Model with Pooling fixed
Fixed bug with using TMyTable in Disconnected Model
Fixed bug with executing multi-statement queries in Disconnected Mode
Bug when UnPrepare is not called for TCustomDASQL on changing value of a macro fixed
Fixed bug with updating views
Fixed bug with FieldDefs.Update on complicated queries
Fixed bug with MySQL Developer Tools connection checking
Fixed bug with refreshing values of the TINYINT(1) fields
Fixed bug in the MyDataAdapter component with reading BLOB fields
Fixed bug with loading DataSet Manager package in a localized IDE
Fixed minor bugs in DataSet Manager
Fixed Access Violation bug on Delphi 2006 exit on Windows Vista
Fixed minor bugs in installation for C++Builder and Delphi 2007

5.00.1.6 20-Apr-07

SSH protocol supported via Core Lab SecureBridge component set
Added support for DevExpress controls in DataSet Manager
FastScript v1.9 support added
Added support for using TMemDataSet.IndexFieldNames with RefreshQuick
TMyDump performance improved
Now TMyDump controls connection character sets in the generated SQL scripts
Fixed bug with executing parametrized queries in Detail dataset from design-time editor
Fixed access violation when loading DataSet Manager package under Delphi 2007 and Windows Vista
Fixed bug with DataSet Manager when IDE freezes on loading a form with a large quantity of datasets
Bug with calling TDataSet.Edit for master DataSet in CachedUpdates mode fixed
Bug with setting RecNo property for filtered datasets fixed
Bug with PSGetTableName returning incorrect value after changing the SQL property fixed
Fixed bug with SQL Generator in design time
Minor bugs in installation fixed
Fixed bug with trimming SQL texts in design-time editors
Fixed access violation on closing Delphi 2005 when MySQL Developer Tools is installed
Fixed bug in SQL Generator with generating REFRESH statements for detail DataSet
Fixed bug with displaying invalid object property type in object inspector
Fixed bug with filter expression that contains several consecutive left brackets
Fixed bug with opening queries with complex field names
Fixed AV failure with deleting records in CachedUpdates mode
Fixed bug when detail DataSet is refreshed on switching master DataSet to Edit mode
Fixed bug with loading files in TMyScript editor
Fixed bug with calling design-time editors of TDADataSource descendants by double click
Fixed bug with creating components from Developer Tools database explorer window
Fixed bug with the RefreshQuick method and SELECT statements containing column aliases
Fixed bug in RefreshQuick method with semicolon at the end of the SELECT statement
Fixed bug with detecting MySQL Developer Tools
Fixed bug with focus in SQL editor when MySQL Developer Tools installed
Fixed bug in TMyConnection editor with choosing a connection name that is unknown to MySQL Developer Tools
Fixed bug with MySQLBuilder menu items
Fixed bug with sockets leak under Linux

5.00.0.5 06-Apr-07

Now stored procedures list are retrieved from the information_schema if possible
ConnectDialog demo added
DataSet Manager stability improved
Bug with setting RecNo property for filtered datasets fixed
Bug with Locate on ordered data fixed
Fixed bug with DefaultValues option and MySQL 5.0.37
Fixed bug with calling RefreshQuick method for MyDAC DataSet with parameters in query
Fixed bug with master/detail relationship with semicolon at the end of the detail query
Fixed bug with TMyDataSetOptions.DefaultValues property for DATETIME fields
Fixed bug with FieldDefs.Update and queries that return multiple result sets
Fixed bug with opening queries with aggregate functions
Fixed bug with executing queries that contain assignment operators
Fixed bug with XmlTextReader.Eof property under C++Builder

5.00.0.4 22-Mar-07

New functionality:

Delphi 2007 for Win32 supported
Disconnected model for working offline and automatically connecting and disconnecting supported
Local failover for detecting connection loss and implicitly reexecuting some operations supported
Added DataSet Manager to control project datasets
Integration with MySQL Developer Tools 2.00 added
New TCRBatchMove component for transferring data between all types of TDataSets descendants added
Output parameters from stored procedures and functions retrieval supported
Data export and import to/from XML supported
WideMemo field type in Delphi 2006 supported
AutoRefresh mode support added
Option to break long-duration query execution added
Ability to search for installed MySQL servers on the network added
Support for sending messages to DBMonitor from any point of your program added

Support for more MySQL server functionality:

HANDLER syntax support in TMyTable added
Enumeration values retrieval for the ENUM and SET fields added

Extensions and improvements to existing functionality:

General performance improved
Master/detail functionality extensions:
- Local master/detail relationship support added
- Support for master/detail relationships in CachedUpdates mode added
TMyScript component improvements:
- Support for executing individual statements in scripts added
- Support for executing huge scripts stored in files with dynamic loading added
- Ability to use standard MySQL client tool syntax added
Working with calculated and lookup fields improvements:
- Local sorting and filtering added
- Record location speed increased
- Improved working with lookup fields
Greatly increased performance of applying updates in CachedUpdates mode
Connection pool functionality improvements:
- Efficiency significantly improved
- API for draining the connection pool added
Option to ignore or replace records with duplicated key values in TMyLoader added
Enhanced TMyServerControl functionality for working with server values
Ability to customize update commands by attaching external components to TMyUpdateQuery objects added
Ability to include all fields in automatically generated update SQLs added

Usability improvements:

Syntax highlighting in design-time editors added
Completely restructured and clearer demo projects

4.40.0.26 12-Aug-08

Improved working with master/detail relationship
Fixed bug with processing Unicode in parameters and BLOBs
Fixed bug with freezing when executing some SQL queries
Fixed bug with executing prepared queries
Fixed bug with memory leak on error in TCustomDADataSet
Fixed bug with memory leak in TFieldDefs.Update
Fixed bug with deleting manually added macros on assigning values to them

4.40.0.25 07-Jun-07

Fixed bug with AV failure after second call to CommitUpdates when there are skipped records in cache
Bug when UnPrepare is not called for TCustomDASQL on changing value of a macro fixed
Fixed bug in the MyDataAdapter component with reading BLOB fields
Fixed bug with DefaultValues option and MySQL 5.0.37

4.40.0.24 27-Mar-07

Added possibility to use connection pooling in ODAC, SDAC, IBDAC and MyDAC at the same time.
Now stored procedures list are retreived from the information_schema if possible (M19458)
Bug with setting the RecNo property for filtered datasets fixed
Bug with using alternative memory managers fixed
Bug with deleting field from TVirtualTable fixed
Fixed bug with WideString lookup fields under Delphi 2006 (M19051)
Fixed bug with RefreshQuick and BLOB fields (M19310)

4.40.0.23 16-Feb-07

FastReport 4 support added
Editor for the MasterFields property of TCustomDADataset in C++Builder added
Fixed bug with TMyCommand::Execute ambiguity under C++Builder (18239)
Fixed bug with table name quotations in the RefreshQuick method (17799)
Fixed bug with fetching large VARCHAR values
Bug with the IndexFieldNames property not working for detail dataset in master/detail link fixed
Bug with reading and writing Unicode BLOB through TBlobStream on computers with multibyte character set fixed
Bug with utf8 to Unicode conversion fixed

4.40.0.22 05-Dec-06

Added ability to make Master/Detail relationship by TBytesField
Fixed bug in TMyDump with field names that contain point

4.40.0.21 05-Dec-06

Added support for Boolean parameter type (15825)
Fixed bug with posting read-only fields (16492)
Fixed bug with connection pooling in FethAll=False mode (15836)
Fixed bug with SHOW FIELDS in Direct mode
Fixed bug with unpreparing statements (16032)
Fixed bug with TraceFlags in DASQLMonitor (D16224)
Fixed bug with TDAParam.AsDate property (D16213)
Fixed bug with wrong value of the StatementTypes variable in the BeforeUpdateExecute event
Bug with AV failure when modifying VirtualTable data in design time fixed

4.40.0.20 31-Oct-06

Optimized TDALoader.CreateColumns method (15322)
Fixed bug with applying updates via MIDAS (14748)
Fixed bug with generating scripts for stored procedures in TMyDump (15255)
Some bugs with object names in TMyDump fixed (15480)
Bug with comparing Unicode strings fixed
Bug with BeforeDisconnect event lost in design time fixed
Bug with debug mode in design time fixed
Bug with RefreshRecord in CachedUpdates mode fixed
Bug with mouse wheeling in FilterBar and Search bar of CRDBGrid fixed (15675)

4.40.0.19 29-Sep-06

Fixed bug with generating queries in TMyQuery design-time editor
Fixed bug with editing queries in TMyDump design-time editor
Fixed bug with macros and "&" operand

4.40.0.18 28-Aug-06

Support for Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ added
Avoided MySQL server bug with CONCAT function result in MyConnection.UseUnicode=True mode
Bug with assertion on dumping tables with complex name fixed (13560)
Fixed bug with running MySQLBuilder Add-in under limited user account (13455)
Fixed bug with working with temporary tables in design-time (12666)
Bug with automatic detail field value generation fixed (D12886)
Fixed bug with TrimVarChar
Fixed bug with FindKey method when the primary key has field of type Int64 (D12558)
Added capability to use quoted field names in IndexFieldNames property (D10091)
Bug with canceling edit on record with BLOB fields fixed
Bug with WideString lookup fields size fixed
Bug with loading wide strings in TVirtualTable fixed
Added support for macros names in which first symbol is digit
Bugs with parsing macros fixed
Bug with filtering DateTime fields when filter expression format differs from one in local system fixed (D12823)

4.30.1.17 07-Jul-06

Fixed bug with input parameter of type Data in stored procedure editor (12286)
Fixed bug with choosing stored procedure in Stored Procedure Editor when Connection is not set (12366)
Fixed bug with wrong line number in DAScript.EndLine property (M12015)
Fixed bug with filtering empty strings (S12329)
Bug with using calculated and lookup fields in Master/Detail relationship fixed
Fixed bug with design-time editor for Detail dataset in Master/Detail relationship (M12021, M11914)
Bug with modifying FieldDefs in TVirtualTable fixed
Performance of SaveToFile and LoadFromFile functions in TVirtualTable improved (D12435)
Bug in TVirtualTable Editor fixed

4.30.1.16 06-Jun-06

Fixed bug with fetching some floating-point values calculated on server

4.30.1.15 31-May-06

Modifying FieldDefs in TVirtualTable component accelerated
Fixed bug with big values of autoincrement fields (11635)
Fixed bug with memory leak in TCustomDADataSet (11636)
Bug with calling Parameter Editor from Object Inspector fixed (11671)
Bug with Master-Detail linked by parameters fixed

4.30.1.14 18-May-06

MyDAC is now compatible with InterBase Data Access Components

4.30.0.13 12-May-06

Missing file MyEmbConnection.hpp added for C++Builder 2006. (11470)
Fixed bug with calling TMyTable.Prepare (11441)
Fixed bug with processing empty string parameter with MyConnection.Options.UseUnicode=True mode (11469)
Fixed bug with fetching long float values (11403)
Fixed bug with FieldDefs.Update in FetchAll=False mode (11409)
Fixed bug with Currency parameters (11360)
Fixed bug with loosing connection for FetchAll=False datasets (M11398)
Added support for MIDAS TDataSet.PSExecuteStatement ResultSet parameter (M11351)
Fixed bug with AV failure in ApplyUpdates after CommitUpdates
Bug with local filter under CLR fixed (11291)
Bug with using alternative memory managers fixed

4.30.0.12 14-Apr-06

Fixed bug with positioning in grid after TCustomDADataSet.Locate (11256)
Fixed bug with Master/Detail relations and local sorting and filtering (11254, 11255)
TCustomDADataSet.Locate now centers position in DBGrid (10976)
Fixed some bugs with views in TMyDump
Fixed bug with getting declaration of ENUM fields on EXPLAIN statements for MySQL 4.1 and older (11007)
Fixed bug with FORMAT function result in MyConnection.UseUnicode=True mode
Fixed bug with SHOW CREATE TABLE in MySQL 4.0
Fixed bug with calling TCustomMyQuery.Prepare method in Direct=False mode (10765)
Bug with displaying query objects in objects tree in DBMonitor fixed
Optimized using of system resources when opening query (O11270)

4.30.0.11 10-Mar-06

Improved performance of updating recordsets with multiple fields
Fixed bug with erroneous exception on TDAParam.LoadFromStream
Bug with SSL fixed
Bug with AV failure when calling CommitUpdates method of inactive dataset fixed
Bug with error failure when assigning empty dataset to VirtualTable under CLR fixed
Fixed bug with wrong reference to QT on Kylix C++ console applications
Fixed bug with "Command Out of Sync" error for prepared datasets in FetchAll=False mode
Fixed bug with "Net packet out of order" error for multistatement command
Fixed bug with closing datasets in FetchAll=False mode
Fixed bug with changing TCustomMyDataSet.SQL property for prepared statements
Fixed bug with non-standard NumericType in FetchAll=False mode

4.30.0.10 26-Jan-06

Support for Delphi 2006 added
BIT fields of MySQL 5.0 and above are now represented as TLargeintField
FastReport 3.20 support added
Added server version checking on Prepare method
Added capability to close DataSet quicker when FetchAll property is False
Fixed bug with opening prepared statements
Fixed bug with setting values to BIT fields in MySQL 5 with SQL_STRICT mode
Fixed bug with truncating field values for "SHOW SLAVE STATUS" statements
Fixed bug with 'delimiter' keyword in TMyScript
Fixed bug with single MacroChar in string constants inside SQL
Bug with invalid processing of SQL statements when using SQL keywords as macros name fixed

4.00.2.8 19-Dec-05

Added BIT and INTEGER types support in parameters of stored procedures
Bug with restoring BaseSQL property fixed

4.00.2.7 07-Dec-05

Added 'delimiter' keyword support in TMyScript
TCustomDADataSet.FindKey, TCustomDADataSet.FindNearest methods added for BDE compatibility
Fixed bug with CREATE TRIGGER statements in TMyScript
Fixed bug with SetOrderBy function
Fixed installator bug with Delphi 2005
Fixed bug with Locate by multiple fields
Fixed bug with unchanging RecordCount value after CancelUpdates
Bug with refreshing record after changing SQL property fixed

4.00.1.6 24-Oct-05

Added capability to prevent simultaneous access of several MyEmbConnection instances to single data folder
Fixed bug with MyEmbConnection under C++Builder and Kylix
Fixed bug with FieldDefs.Update
Bug with updating FilterSQL fixed
Bug with VirtualTable registration in CBuilder fixed
Bug with VtReg.pas in Pro version fixed
Bug with closing dataset (SQL contains macros) when the InsertSQL property changes fixed
Bug with incorrect sequence of calling BeforeClose, BeforeDisconnect events fixed

4.00.1.5 11-Oct-05

FieldDefs.Update behavior in case of temporary tables improved
Fixed MySQL server bug with DESCRIBE statements
Fixed bug with Master/Detail relations and LOCK clause
Fixed bug with LOAD INTO statements
Fixed bug with setting TMyStoredProc.FetchAll to False in design-time
Fixed bug with describing fields for parametrised prepared statements
Fixed bug with Master/Detail relations on string keys that differ in case only
Bug with reexecution after SQL statement changed fixed
Bug with assertion failure with OnNewRecord fixed
Fixed bug with detail refresh when field referenced by MasterFields property is empty
Fixed bug with extra detail record posts after master record changed
Bug with firing AfterScroll Event after detail dataset refresh fixed
Bug with simultaneous use of several DAC products fixed
Bug with changing FilterSQL of inactive dataset fixed
Bug with column sizing with CRDBGrid.OptionsEx.dgeStretch=True at design-time fixed
Bug with TCRColumn.SummaryMode=smLabel for string and date fields fixed

4.00.1.3 02-Sep-05

Deferred detail dataset refresh feature with TCustomDADataSet.Options.DetailDelay property added
TCustomMyConnection.Ping behavior in case connection loss improved
Fixed bug with two Stored Procedures with same names from different databases
Fixed bug with locating, filtering and local sorting of strings that contain '--'
Fixed DisposeBuf bug
Fixed bug with calculating percent in TMyDump.OnRestoreProgress for huge scripts
Fixed bug with SHOW statement and TMyConnection.Options.UseUnicode mode
Fixed bug with TMyConnection.ExecSQL and recordsets
Fixed bug with FieldDefs.Update and multi-statement query
Fixed bug with Field.FieldName case sensitivity
Fixed bug with reopening recordset after connection lost
Fixed bug with old libmysql in MyConnection.Options.Direct = False mode

4.00.0.2 04-Aug-05

Optimized macros processing
Fixed bug with getting default values for float fields
Fixed bug with TCustomMyDataSet.IndexFieldNames set at design-time
Fixed bug with adding WHERE to statements with ORDER BY or LIMIT clauses
Fixed bug with fetching BCD values with large precision
Fixed bug with MySqlVioTcpSSL on Kylix

4.00.0.1 29-Jul-05

Unicode support added
Enhanced support for MySQL Embedded Server with TMyEmbConnection component added
Binary protocol support for MySQL 4.1 and above added
Encrypted SSL connections support with OpenSSL added
Enhanced support for national charsets added with TMyConnectionOptions.Charset property
BLOB compression support added
RefreshQuick for TCustomMyDataSet added
Retrieve field's default value added with TCustomMyDataSet.Options.DefaultValues property
Large amount of data support for TMyDump added
Server start/stop ability for TMyServerControl added
TMyBuilder component added for easy using MySQLBuilder at run-time
FAQ added
Tested with MySQL server 5.0.9

3.55.0.22 05-Jul-05

Percent calculating bug in TMyDump.OnRestoreProgress is fixed
Bug with TDAParam.AsString with TDataTime parameters fixed

3.55.0.21 30-May-05

MySQL 5.0.3 BIT type support added
Optimized MySQLMonitor BLOB parameters processing
Ability of automatic preparing query with TCustomDADataSet.Options.AutoPrepare property added
Ability to synchronize position at different DataSets with TCustomDADataSet.GotoCurrent method added
Fixed bug with parsing alias
Fixed bug with range-checking error on describe fields in Direct mode
Fixed bug with GetOrderBy
Fixed bug with DESC <table>
Fixed trial version AV bug on Win2003 SP1

3.50.0.20 29-Apr-05

Update Pack 3 is required for Delphi 8
Fixed design-time TMyTable AV bug
Fixed bug with TMyCommand.CommandTimeout default value
Fixed design-time TMyTable bug with unexpected connect on project opening

3.50.0.19 07-Apr-05

DECIMAL column type in MySQL 5.0.3 support added
Fixed bug with ' in scripts
Fixed bug with command executing performance in Direct mode
Fixed bug with TMyTable.IndexDefs

3.50.0.18 29-Mar-05

Lock Demo added
Fixed bug with performance in Direct mode
Fixed bug with small memory leak in Direct mode
Fixed bug with processing quote("'") in TMyScript string literals
Fixed bug with processing DateTime fields in TMyLoader and TMyDump
Fixed bug with processing DateTime params
Fixed bug with quoting fields in SQLRefresh
Fixed bug with setting MinValue and MaxValue for TFMTBCDField
Fixed design-time bug with deleting TMyTable component

3.50.0.17 24-Feb-05

CommandTimeout default value set to 0 (infinite)
TCustomDADataSet.UpdateObject support for MIDAS added
Fixed "Net packets out of order" bug
Fixed bug with tfMisc in TMySQLMonitor.TraceFlags
Fixed bug with detach file on LOAD DATA in Direct mode
Fixed bug with Direct and multithreading
Fixed bug with CLR BLOB Locate
Fixed bug with FmtBCD Locate

3.50.0.16 21-Jan-05

Support for Delphi 2005 added
TMySQLMonitor.OnSQL can return statement encoded to an escaped SQL string
Support for ConnectionTimeout in TMyConnection.ExecSQL added
Fixed bug with LOAD DATA LOCAL INFILE in Direct mode
Fixed bug with design-time SQL generator and macros
Fixed bug with MyConnection.Ping in Direct mode
Fixed bug with FetchAll = False in Direct mode
Fixed bug with TMyConnection.IsolationLevel
Fixed bug with KeepDesignConnected
Fixed infrequent bug with IndexFieldNames
Fixed design-time bug with deleting TDALoader.Connection component
Fixed design-time bug with TDALoader columns
Fixed bug with TDALoader in Kylix
Fixed bug with disconnect on fatal error

3.30.2.15 22-Dec-04

TCustomMyDataSet.CommandTimeout property added
TMyCommand.CommandTimeout property added
"True" value for boolean fields and parameters stored as "1"
Connecting with database not specified bug fixed
Fixed bug with connection loss on long queries
Fixed bug with updating SELECT with ";" after table name
Fixed bug with decimal separator on Delphi 5(C++Builder 5)
Fixed bug with range-checking on describing fields
Fixed design-time bug with deleting TMyDump(TMyBackup).Connection component
Fixed bug with generating update queries and float fields in WHERE clause
Fixed small bug with Embedded Server Demo

3.30.1.13 23-Nov-04

Ability to store only a part of data in TMyDump.BackupQuery added
Creating additional connection for TMyDump disabled
Fixed bug with design-time SQLGenerator and QuoteNames
Fixed bug with boolean fields in TMyDump
Fixed bug with SP in MySQL 5.0.1
Fixed bug with IndexFieldNames and Locate
Fixed bug with 4.1 authentication with empty Database
Fixed bug with memory leaks on connection lost
Fixed bug with KeepDesignConnected
Fixed bug with getting TCustomMyTable.IndexDefs for MySQL 4.1

3.30.0.12 28-Oct-04

Fixed C++Builder hpp bug
Fixed bug with TMyTable update
Fixed bug with fetching empty strings in Direct mode

3.30.0.10 21-Oct-04

Full support for all current authentication protocols added
Generating update SQL for tables from other database added
TCustomMyDataSet.Options.EnableBoolean property added
TMyConnection.ThreadId property added
lxPartialCompare option for DataSet.LocateEx added
FastReport3 engine and demo added
Fixed rare bug with changing decimal separator
Fixed bug with OnFilterRecord and Blob fields (S4962)
Fixed Locate string bug under Kylix
Fixed bug with Reconnect and prepared statements (S4910)
Fixed bug with BlobField.SetAsString
Fixed bug with QuoteNames and Master-Detail relationship

3.10.2.8 10-Sep-04

Common class DADataAdapter isolated to CoreLab.Dac.AdoNet.dll library
Fixed bug with evaluation period in Trial version
Fixed bug with TDAConnectionOptions.AssignTo
Fixed bug with SHOW CREATE in TMyDump
Fixed bug with filtering NULL string values (S4776)
Fixed bug with large blobs in TVirtualTable (4769)

3.10.1.7 20-Aug-04

Fatal errors processing improved
TINYINT(1) fields now represented as TBooleanField

3.10.1.6 22-Jul-04

Assembly CoreLab.MyDac.Data renamed to CoreLab.MyDac.AdoNet
Fixed bug with Delphi8 Informal Update 3 for ASP.NET
Fixed NRE with flat (wide)string processing (CLR only)
Fixed bug with IndexDefs string field processing (CLR only)

3.10.0.5 08-Jul-04

Local sorting ability with TMemDataSet.IndexFieldNames added
TCustomMyTable.IndexDefs property added
TMyConnection.Options.NumericType property added
TMyStoredProc component added
MyDataAdapter component added
Fixed bug with generating SQLUpdate for tables with complex primary keys (4535)
Fixed memory leak at CLR params processing
Fixed bug with mask in TCustomDADataSet.Filter
Fixed bug with simultaneously installed CBuilder5 and Delphi5 versions

3.00.1.4 26-May-04

Trial version IDE warning disabled
TCRColumn.TotalValue property added
Trial version AV bug fixed (BLOB support)
Fixed some bugs with using DAC in Dll
Memory leak fixed
Fixed bug with Local filtering (DateTime fields)
Fixed bug with int64 locate
Fixed assertion with TMyConnectDialog.Execute without MyConnection (4434)
MyBackup bug fixed

3.00.1.3 29-Apr-04

TCustomMyDataSet.Options.LongStrings property added
TMyLoader.OnPutData event published again
Fixed bug with trimming non-binary BLOB with #0 (4246)
Memory leak on SQL property changing fixed
Bug with title of TCRDBGrid when RecordCount=1 fixed
Bug with locating record by DATE field fixed (O4257)
Bug with IsNull value in lookup string fields fixed
Bug with opening TCustomDADataSet if Filtered = True fixed (O4251)

3.00.0.2 09-Apr-04

Support for Delphi 8 added
MySQL 5.00 support added
Connection pooling support
Performance improved
TMyLoader performance greatly improved
TCRGrid sources in Standard edition
.NET Windows Forms demo project added
ASP.NET demo project added
Global variable MySQLClientLibrary added
New time trial limitation
Fixed bug with CustomDADataSet.Options.ReturnParams (S4159)
Fixed bug with CRDBGrid
Fixed bug with resetting TMyLoader.TableName
Bug in FastReport Demo fixed
Fixed bug with getting RecordCount with Filtered = True (S4125)
Fixed bug with getting OldValue after Insert

2.00.3.6 15-Mar-04

Mouse wheel support added to CRDBGrid
MySQL Embedded server Demo added
ConnectDialog Demo added
Fixed bug with quote char in Filter property
Fixed bug with embedded server startup if standard is not installed
Autostop of MySQL server on embedded server startup is disabled

2.00.3.5 05-Feb-04

SELECT '' support added
Method TMyConnection.Ping added
Method TMyConnection.GetExecuteInfo added
Autostop normal server on start embedded added
Fixed bug with TCustomMSDataSet.PSGetKeyFields (4001)
Fixed bug with QuoteNames
Fixed bug with datadir checking on embedded server start
Fixed bug with large ID values for Direct mode
Fixed bug with restoring position after Refresh (3962)

2.00.2.4 30-Dec-03

BDE Migration Wizard algorithm optimized
Limited MySQL server 4.1.1 support added
If libmysql.dll not found then raise EOSError (instead of Exception)
Property TCustomMyDataSet.InsertId: int64 added
Timestamp support added for CheckRowVersion = True
Fixed bug with TMyScript.Debug (DataSet <> nil)
Fixed bug with MacroChar('%') in TMyScript
Fixed bug with MyDump.Backup in binary mode
Fixed bug with empty string values in Direct mode (3730)
Fixed bug with WHERE + LIMIT
Fixed rare bug with processing '?' in string literals

2.00.1.3 24-Nov-03

Property MyConnection.Options.Direct is set to True by default
TCustomMyDataSet.Lock method added
AutoInc fields can be modified now
Fixed bug with SHOW CREATE TABLE on MySQL client 4.0.12 - 4.0.14 (3578)
Fixed bug with simultaneous use of Filter and FilterSQL (3615)
Fixed small design-time bug with TMyScript.DataSet (3678)
Fixed bug with ORDER BY + LIMIT

2.00.0.2 14-Oct-03

WHERE clause generating algorithm improved

2.00.0.1 02-Oct-03

Access to MySQL without client library using DirectMySQLObjects by Cristian Nicola
Prepare support and new parameter binding schema for MySQL 4.1 added
Supports working with MySQL server and Embedded server at the same time
BDE migration wizard
TMyDump component to store a database or its parts as a script
TMyBackup component for backup coping specified tables on the server
TMyServerControl component to manage the server and standard service tasks execution
TMyLoader component for fast loading data to the server
New options of TMyConnection such as Compress, Protocol, Direct and Embedded added
New properties ClientVersion, ServerVersion were added to TMyConnection
Method ExecSQL in TMyConnection added
Methods GetTableNames and GetDatabaseNames in TMyConnection added
Property TMyConnection.Charset added
Property TMyConnection.IsolationLevel added
Methods LockTable and UnlockTable added to TCustomMyDataset
Properties Limit and Offset added to TCustomMyTable
Method TCustomMyTable.EmptyTable added
FetchAll set to True by default
Large SQL (INSERT/UPDATE BLOB's) executing performance greatly improved
Bug with opening queries (FilterSQL <> '', StreamedActive = True) fixed (3497)
Fixed bug with calling Refresh after RefreshRecord (3269)
Fixed bug with design-time EdMyParam on Master/Detail relations (3155)

1.50.0.15 04-Jul-03

Fixed bug with datadir check for Embedded Server
Fixed bug with design-time EdMyScript for Kylix (3091)

1.50.0.14 02-Jul-03

MySQL Embedded Server support added for Kylix
Check for datadir present added
Changed behavior on calculating affected rows count
Fixed bug with possible AV on destroying DataSet in Delphi5 (S3069)

1.50.0.13 06-Jun-03

MySQL Embedded Server support added
MySQL Server 4.1 limited support added
Properties Port and Database in ConnectForm added
RefreshRecord performance improved
InfoPower demos added
'Explain query...' added to design-time MyQuery menu
'Show CREATE...' added to design-time MyQuery and MyTable menus
SQL Generator improved - support for complicated statements added
SQL Generator improved - "Quote names" checkbox added
Complex keys support added
Design-time SQL Generator was simplified
TParam -> TDAParam
Fixed bug with trimming char fields having empty values (S2987)
Bug on Post (Insert/Append) when InsertSQL execution fails fixed
Fixed bug with call RefreshRecord on SELECT w/o data fields
Fixed bug with Locate TIME fields
Fixed bug with autosetting MyCommand.ParamCheck in design-time editor
Fixed bug with ParamCheck = False (3044)
Fixed bug with fetching value for "Null" column in "SHOW COLUMNS ..." query

1.30.2.12 05-May-03

Search algorithm for 'libmysqlclient.so' under Linux improved
Fixed inconvenience with getting databases list if MyConnection.Database was wrong

1.30.2.11 04-Apr-03

unit MySQLAccess renamed to MyClasses
MyBuilder bug fixed
Property TMyDataSetOptions.LongStrings removed
Parameters parsing improved. Symbol ':' in string literals is ignored (S2836)
Fixed bug with changing MyDAtaSet.Options.FieldsAsString and design-time fields (2905)

1.30.1.10 24-Feb-03

Refresh improved - current record is restored after Refresh call
Property MyConnection.Options.KeepDesignConnected added
Property MyConnectDialog.StoreLogInfo published
Property MyScript.DataSet was published (2733)
Property TMyCommand.InsertId: int64 added
TINYTEXT -> TMemoField, TINYBLOB -> TBlobField
Support for TIMESTAMP (10), TIMESTAMP (4), TIMESTAMP (2) added
Support for LIKE expressions in Filter property added (D2706)
Fixed bug with TMyConnection.SetPort in CBuilder
Bug with UNSIGNED INT processing fixed
Bug with fetching '(var)char binary' fields fixed (2642)
Bug in MyTable.Execute fixed

1.30.0.9 03-Feb-03

Bug with describe fields on 3.23 client fixed

1.30.0.8 30-Jan-03

MySQL v4.0 support added
Dataset 'with many fields' update performance improved
Improved performance for opening queries with lot of parameters

1.20.0.7 04-Jan-03

Fetch performance improved for DataSet.FetchAll = True
'Connection Lost' error processing improved
'Prepare' button removed from demos
Fixed bug with memory leaks on DataSet.FetchAll = False (2547, 2548)
Fixed bug with DataSet.Last on DataSet.FetchAll = False
Fixed small bug with design-time MSConnection editor (1648)
Bug with string quote in filter expression fixed (O2532)

1.20.0.6 26-Dec-02

Kylix2 and Kylix3 support
ReportBuilder demos added
DBMonitor client implementation moved to COM server
Fixed common bug with lost data in DT-editors (D2137)
Bug with design-time MSConnection in DataModule fixed (O2290)
Bug with Master/Detail relation for ClientDataSet fixed (O2423)
Fixed small bug with error processing
Fixed bug with executing wrong script at design-time (2279)

1.10 08-Oct-02

Delphi 7 support
New memory management model for ftString and ftVarBytes types. Allows significantly decrease memory usage on
Large tables fetch. Controlled by FlatBuffers dataset option
Support for blob fields in CachedUpdates mode

1.00 26-Aug-01

Initial release of MyDAC