Please try MySQL Server Data Access Components 5.00 Beta version available for download now.
Version 5.00 introduces a large number of new features including disconnected model and local failover support,
extended server-specific functionality support and many others.
Here is the description of new features:
New functionality:
- Disconnected model for working offline and automatically connecting and disconnecting supported
- Local failover for detecting connection loss and implicitly reexecuting some operations supported
- Added support for SSH protocol via CryptoLibrary component set
- Added DataSet Manager to control project datasets
- New component for transferring data between all types of TDataSets descendants added
- Added support for retrieving output parameters from stored procedures and functions
- Data export and import to/from XML supported
- AutoRefresh mode supported
- Option to break long-duration query execution added
- Ability to search for installed MySQL servers in the local network added
- Support for sending messages to DBMonitor from any point of your program added
- HANDLER syntax supported in TMyTable
- Added support for retrieving enumeration values for the ENUM and SET fields
- Master/detail functionality extensions:
- Local master/detail relationship support added
- Master/detail relationship in CachedUpdates mode support 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
- Syntax highlighting in design-time editors added
- Easy-to-use demo projects
Core Lab development team
http://www.crlab.com/mydac