彩票走势图

• 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

• 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