mysql data access components_Data Access Components for MySQL

Data Access Components for MySQL (MyDAC) is a library of components that provides direct access to MySQL database servers from Delphi, Delphi for .NET, C++Builder and Kylix. MyDAC can connect directly to MySQL server or work through the MySQL client library. The MyDAC library is designed to help programmers develop faster and cleaner MySQL database applications.

MyDAC is a complete replacement for standard MySQL connectivity solutions and presents an efficient alternative to the Borland Database Engine for access to MySQL.

Data Access Components for MySQL (MyDAC) is a library of components that provides direct access to MySQL database servers from Delphi, Delphi for .NET, C++Builder and Kylix. MyDAC can connect directly to MySQL server or work through the MySQL client library. The MyDAC library is designed to help programmers develop faster and cleaner MySQL database applications.

MyDAC is a complete replacement for standard MySQL connectivity solutions and presents an efficient alternative to the Borland Database Engine for access to MySQL.

功能描述

需要培训、定制、外包？

请联系我们！企业QQ：800018081

慧都专业技术团队帮助您提高效率，节省成本，降低风险！

* 关于本产品的分类与介绍仅供参考，精准产品资料以官网介绍为准，如需购买请先行测试。

Components

All editions of MyDAC include the following basic components:

TMyConnection - lets you set up and control connections to MySQL database server

TMyQuery - uses SQL statements to retrieve data from MySQL table or tables and supply it to one or more data-aware components through a TDataSource component and provides flexible data update functionality

TMyTable - allows to retrieve and update data single table without writing SQL statement

TMyStoredProc - executes stored procedures and functions

TMyCommand - executes SQL statements and stored procedures, which do not return rowsets

TMyScript - executes sequence of SQL statements

TMyUpdateSQL - lets you tune update operations for a DataSet component

TMyDataSource - provides an interface between a MyDAC dataset components and data-aware controls on a form

TMySQLMonitor - allows to monitor dynamic SQL executing in MyDAC based applications

TMyConnectDialog - allows you to build custom prompts for usernames, passwords, and servers

TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search

TVirtualTable - provides dataset functionality for data that has no real database connection

MyDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

MyDAC Professional Edition and MyDAC Developer Edition include the following additional components:

TMyLoader - provides quick loading data to MySQL database

TMyDump - serves to store a database or its parts as a script and also to restore database from received script

TMyBackup - serves for backup copying specified tables on the server

TMyServerControl - serves to control the server and execution of standard service tasks

TMyEmbConnection - is used to establish connection to MySQL Embedded server

TMyBuilder - serves to manage SQL Builder for MySQL Add-in

TMyMetaData - retrieves metadata on specified SQL object

TCRBatchMove - transfers data between all types of TDataSet descendantsKey Features

The following list describes the main features of Data Access Components for MySQL.

Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)

VCL, VCL.NET, and CLX versions of library available

Full support of the latest versions of MySQL Server

Support for all MySQL Server data types

Disconnected Model with automatic connection control for working with data offline

Local Failover for detecting connection loss and implicitly reexecuting certain operations

All types of local sorting and filtering, including by calculated and lookup fields

Automatic data updating with TMyQuery, TMyTable, and TMyStoredProc components

Unicode and national charset support

Supports many MySQL-specific features, such as locking, SET and ENUM types

Advanced script execution functionality with TMyScript component

Support for using macros in SQL

Integration with MyDeveloper Tools for performing advanced database development and administration tasks

Easy migration from BDE with Migration Wizard

Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications

Includes annual MyDAC Subscription with Priority Support

Licensed royalty-free per developer, per team, or per site

Components

All editions of MyDAC include the following basic components:

TMyConnection - lets you set up and control connections to MySQL database server

TMyQuery - uses SQL statements to retrieve data from MySQL table or tables and supply it to one or more data-aware components through a TDataSource component and provides flexible data update functionality

TMyTable - allows to retrieve and update data single table without writing SQL statement

TMyStoredProc - executes stored procedures and functions

TMyCommand - executes SQL statements and stored procedures, which do not return rowsets

TMyScript - executes sequence of SQL statements

TMyUpdateSQL - lets you tune update operations for a DataSet component

TMyDataSource - provides an interface between a MyDAC dataset components and data-aware controls on a form

TMySQLMonitor - allows to monitor dynamic SQL executing in MyDAC based applications

TMyConnectDialog - allows you to build custom prompts for usernames, passwords, and servers

TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search

TVirtualTable - provides dataset functionality for data that has no real database connection

MyDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

MyDAC Professional Edition and MyDAC Developer Edition include the following additional components:

TMyLoader - provides quick loading data to MySQL database

TMyDump - serves to store a database or its parts as a script and also to restore database from received script

TMyBackup - serves for backup copying specified tables on the server

TMyServerControl - serves to control the server and execution of standard service tasks

TMyEmbConnection - is used to establish connection to MySQL Embedded server

TMyBuilder - serves to manage SQL Builder for MySQL Add-in

TMyMetaData - retrieves metadata on specified SQL object

TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features

The following list describes the main features of Data Access Components for MySQL.

Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)

VCL, VCL.NET, and CLX versions of library available

Full support of the latest versions of MySQL Server

Support for all MySQL Server data types

Disconnected Model with automatic connection control for working with data offline

Local Failover for detecting connection loss and implicitly reexecuting certain operations

All types of local sorting and filtering, including by calculated and lookup fields

Automatic data updating with TMyQuery, TMyTable, and TMyStoredProc components

Unicode and national charset support

Supports many MySQL-specific features, such as locking, SET and ENUM types

Advanced script execution functionality with TMyScript component

Support for using macros in SQL

Integration with MyDeveloper Tools for performing advanced database development and administration tasks

Easy migration from BDE with Migration Wizard

Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications

Includes annual MyDAC Subscription with Priority Support

Licensed royalty-free per developer, per team, or per site