Data Access Components for MySQL

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.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 �onnection 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)