New Features in MyDAC 12.1
New Features in MyDAC 12.0
- 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
New Features in MyDAC 11.3
- 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
New Features in MyDAC 11.2
- Added support for RAD Studio 11 Alexandria Release 2
- Added support for Lazarus 2.2.2
- Added support for iOS 15
- Added support for Android 12
- Added the CloneCursor method for Query and Table components that allows sharing data between datasets
- Improved the performance of exporting to XML
- Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption
- Fixed bug with truncation of milliseconds of DateTime fields in the Dump component
- Fixed bug with posting calculated field
- Fixed bug when a connection string parameter value contains a single quote
New Features in MyDAC 11.1
- RAD Studio 11 Alexandria Release 1 is supported
- Lazarus 2.2.0 is supported
- Windows 11 is supported
- macOS Monterey is supported
New Features in MyDAC 11.0
- RAD Studio 11 Alexandria is supported
- macOS ARM is supported
- Added demo project for FastReport FMX
New Features in MyDAC 10.4
- 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
New Features in MyDAC 10.3
- Lazarus 2.0.10 and FPC 3.2.0 are supported
- Performance of Batch Insert, Update, and Delete operations is improved
New Features in MyDAC 10.2
- RAD Studio 10.4 Sydney is supported
- Lazarus 2.0.8 is supported
- macOS 64-bit in Lazarus is supported
New Features in MyDAC 10.1
- 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
New Features in MyDAC 10.0
- 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
New Features in MyDAC 9.4
- 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
New Features in MyDAC 9.3
- 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
New Features in MyDAC 9.2
- 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
New Features in MyDAC 9.1
- Azure Database for MySQL is supported
- JSON data type is supported
New Features in MyDAC 9.0
- 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
New Features in MyDAC 8.7
- 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
- Data Type Mapping performance is improved
- Performance of TDALoader on loading data from TDataSet is improved
New Features in MyDAC 8.6
- 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
New Features in MyDAC 8.5
- RAD Studio XE8 is supported
- AppMethod is supported
New Features in MyDAC 8.4
- RAD Studio XE7 is supported
- Lazarus 1.2.4 is supported
- The TCustomDADataSet.GetKeyFieldNames method is added
- The ConstraintColumns metadata kind for the TMyMetaData component is added
- Demo projects for FastReport 5 are added
New Features in MyDAC 8.3
- 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
New Features in MyDAC 8.2
- 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
New Features in MyDAC 8.1
- 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
- The possibility to use conditions is added
- Support of the IN keyword in the TDataSet.Filter property is added
- Like operator behaviour when used in the Filter property is now similar to TClientDataSet
- The possibility to use ranges is added
- The AllowImplicitConnect option for the TMyConnection component is added
- The SQLRecCount property for the TMyQuery and TMyStoredProc components is added
- The ScanParams property for the TMyScript component is added
- The RowsAffected property for the TMyScript component is added
- ConnectionTimeout is now used when disconnecting after connection loss
New Features in MyDAC 8.0
- Rad Studio XE4 is supported
- NEXTGEN compiler is supported
- Application development for iOS is supported
- FPC 2.6.2 and Lazarus 1.0.8 are supported
- Connection string support is added
- Possibility to encrypt entire tables and datasets is added
- Possibility to determine if data in a field is encrypted is added
- Support for TimeStamp, Single and Extended fields in VirtualTable is added
New Features in MyDAC 7.6
- 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
New Features in MyDAC 7.5
- Rad Studio XE3 is supported
- Windows 8 is supported
New Features in MyDAC 7.2
- Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
- Data Type Mapping support is added
- Data encryption in a client application is added
- The TMyEncryptor component for data encryption is added
- Calling of the TCustomDASQL.BeforeExecute event is added
New Features in MyDAC 7.1
- Update 4 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.4 and FPC 2.6.0 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
New Features in MySQL Data Access Components 7.00
- 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
New Features in MySQL Data Access Components 6.10
- 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
New Features in MySQL Data Access Components 6.00
- Embarcadero RAD Studio XE suppored
New Features in MySQL Data Access Components 5.90
- Embarcadero RAD Studio 2010 supported
New Features in MySQL Data Access Components 5.80
- Free Pascal under Linux supported
- Added NoPreconnect property to TMyScript for executing CONNECT and CREATE DATABASE commands
New Features in MySQL Data Access Components 5.70
- Delphi 2009 and C++Builder 2009 supported
- Extended Unicode support for Delphi 2007 added (special Unicode build)
- Free Pascal 2.2 supported
- Powerful design-time editors implemented in Lazarus
- Completed with more comprehensive structured Help
New Features in MySQL Data Access Components 5.55
- dbForge Fusion for MySQL support added
New Features in MySQL Data Access Components 5.50
- Added compatibility with UniDAC
- Improved support of default field values
- The new component for metadata receiving added
- Added ability to specify key fields for a dataset
- Added support of automatic records locking
New Features in MySQL Data Access Components 5.20
New Features in MySQL Data Access Components 5.10
- C++Builder 2007 supported
New Features in MySQL Data Access Components 5.00
New functionality:
- Delphi 2007 for Win32 supported
- Implemented Disconnected Model for working offline and automatically connecting and disconnecting
- Implemented Local Failover for detecting connection loss and implicitly re-executing some operations
- Support for SSH protocol via SecureBridge component set added
- Added DataSet Manager to control project datasets
- Integration with MyDeveloper Tools 2.00 added
- New TCRBatchMove component for transferring data between all types of TDataSet 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 in your program added
Support for more MySQL server functionality:
Extensions and improvements to existing functionality:
Usability improvements:
New Features in MySQL Data Access Components 4.40
- Optimized TDALoader.CreateColumns method
- Support for Professional editions of Turbo Delphi, Turbo Delphi for .NET, Turbo C++ added
- Added support for macros names in which first symbol is digit
- Added capability to use quoted field names in IndexFieldNames property
New Features in MySQL Data Access Components 4.30.1
- MyDAC is now compatible with InterBase Data Access Components
- Modifying FieldDefs in TVirtualTable component accelerated
- Performance of SaveToFile and LoadFromFile functions in TVirtualTable improved
New Features in MySQL Data Access Components 4.30
- 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
- Improved performance of updating recordsets with multiple fields
- TCustomDADataSet.Locate now centers position in DBGrid
- Added support for MIDAS TDataSet.PSExecuteStatement ResultSet parameter
New Features in MySQL Data Access Components 4.00.2
- Added 'delimiter' keyword support in TMyScript
- TCustomDADataSet.FindKey, TCustomDADataSet.FindNearest methods added for BDE compatibility
- Added BIT and INTEGER types support in parameters of stored procedures
New Features in MySQL Data Access Components 4.00.1
- Deferred detail dataset refresh feature with TCustomDADataSet.Options.DetailDelay property added
- TCustomMyConnection.Ping behavior in case connection loss improved
- FieldDefs.Update behavior in case of temporary tables improved
- Added capability to prevent simultaneous access of several MyEmbConnection instances to single data folder
New Features in MySQL Data Access Components 4.00
- Unicode support added
- Enhanced support for Embedded MySQL 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 SQL Builder for MySQL at run-time
- Optimized macros processing
- FAQ added
- Tested with MySQL server 5.0.9
New Features in MySQL Data Access Components 3.55
- 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
21-Jan-05 MySQL Data Access Components 3.50:
- Support for Delphi 2005 added
- TMySQLMonitor.OnSQL can return statement encoded to an escaped SQL string
- Support for ConnectionTimeout in TMyConnection.ExecSQL added
- CommandTimeout default value set to 0 (infinite)
- TCustomDADataSet.UpdateObject support for MIDAS added
- Lock Demo added
- DECIMAL column type in MySQL 5.0.3 support added
- Update Pack 3 is required for Delphi 8
New Features in MySQL Data Access Components 3.30
- 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
- Ability to store only a part of data in TMyDump.BackupQuery added
- Creating additional connection for TMyDump disabled
- TCustomMyDataSet.CommandTimeout property added
- "True" value for boolean fields and parameters stored as "1"
New Features in MySQL Data Access Components 3.10.2
- Common class DADataAdapter isolated to Devart.Dac.AdoNet.dll library
New Features in MySQL Data Access Components 3.10.1 new features
- Assembly Devart.MyDac.Data renamed to Devart.MyDac.AdoNet
- Fatal errors processing improved
- TINYINT(1) fields now represented as TBooleanField
New Features in MySQL Data Access Components 3.10
- Local sorting ability with TMemDataSet.IndexFieldNames added
- TCustomMyTable.IndexDefs property added
- TMyConnection.Options.NumericType property added
- TMyStoredProc component added
- MyDataAdapter component added
New Features in MySQL Data Access Components 3.00.1
- TCustomMyDataSet.Options.LongStrings property added
- TMyLoader.OnPutData event published again
- Trial version IDE warning disabled
- TCRColumn.TotalValue property added
New Features in MySQL Data Access Components 3.00
- Support for Delphi 8 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
New Features in MySQL Data Access Components 2.00.3
- SELECT '' support added
- Method TMyConnection.Ping added
- Method TMyConnection.GetExecuteInfo added
- Mouse wheel support added to CRDBGrid
- Embedded MySQL Server Demo added
- ConnectDialog Demo added
New Features in MySQL Data Access Components 2.00.2
- 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
New Features in MySQL Data Access Components 2.00.1
- Property MyConnection.Options.Direct is set to True by default
- TCustomMyDataSet.Lock method added
- AutoInc fields can be modified now
New Features in MySQL Data Access Components 2.00
- 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
New Features in MySQL Data Access Components 1.50
- Embedded MySQL 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
- Embedded MySQL Server support added for Kylix
- Check for datadir present added
- Changed behavior on calculating affected rows count
New Features in MySQL Data Access Components 1.30.2
- Unit MySQLAccess renamed to MyClasses
- Property TMyDataSetOptions.LongStrings removed
- Parameters parsing improved. Symbol ':' in string literals is ignored
- Search algorithm for 'libmysqlclient.so' under Linux improved
New Features in MySQL Data Access Components 1.30.1
- Refresh improved - current record is restored after Refresh call
- Property MyConnection.Options.KeepDesignConnected added
- Property MyConnectDialog.StoreLogInfo published
- Property MyScript.DataSet was published
- 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)
New Features in MySQL Data Access Components 1.30
- MySQL v4.0 support added
- Dataset 'with many fields' update performance improved
- Improved performance for opening queries with lot of parameters
New Features in MySQL Data Access Components 1.20
- Kylix2 and Kylix3 support
- ReportBuilder demos added
- DBMonitor client implementation moved to COM server
- Fetch performance improved for DataSet.FetchAll = True
- 'Connection Lost' error processing improved
New Features in MySQL Data Access Components 1.10
- 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
