組件

IBDAC包括以下組件：

• TIBCConnection - 設(shè)置和控制與InterBase數(shù)據(jù)庫的連接

• TIBCTransaction - 提供對數(shù)據(jù)庫連接的離散事務(wù)控制

• TIBCQuery - 使用SQL語句從InterBase表或表中檢索數(shù)據(jù)，自動生成缺少的INSERT、DELETE、UPDATE語句

• TIBCTable - 允許用戶在單個表中檢索和更新數(shù)據(jù)，而無需編寫SQL語句

• TIBCStoredProc - 執(zhí)行存儲過程和函數(shù)，允許編輯作為參數(shù)返回的游標數(shù)據(jù)

• TIBCSQL - 執(zhí)行不返回行集的SQL語句和存儲過程

• TIBCScript - 執(zhí)行SQL語句序列

• TIBCUpdateSQL - 允許用戶調(diào)整DataSet組件的更新操作

• TIBCDataSource - 在表單上提供IBDAC數(shù)據(jù)集組件和數(shù)據(jù)感知控件之間的接口

• TIBCAlerter - 在連接之間傳輸消息

• TIBCMetaData - 檢索指定SQL對象上的元數(shù)據(jù)

• TIBCSQLMonitor - 允許監(jiān)視在基于IBDAC的應(yīng)用程序中執(zhí)行的動態(tài)SQL

• TIBCConnectDialog - 用于輸入用戶名、密碼和服務(wù)器名稱

• TCRDBGrid - 擴展了TDBGrid功能，提供了對過濾器和增量搜索的可視訪問

• TVirtualTable - 數(shù)據(jù)集將數(shù)據(jù)存儲在內(nèi)存中

• IBCDataAdapter - .NET組件，使用TDataSet作為數(shù)據(jù)源，用于檢索和保存數(shù)據(jù)到System.Data.DataSet

• TCRBatchMove - 在所有類型的TDataSet后代之間傳輸數(shù)據(jù)

主要特點

以下列表描述了InterBase數(shù)據(jù)訪問組件的主要功能。

• 直接訪問服務(wù)器數(shù)據(jù)。不需要安裝其他數(shù)據(jù)提供程序?qū)樱ɡ鏐DE和ODBC）

• 提供VCL、VCL.NET和CLX版本的庫

• 完全支持最新版本的InterBase、Firebird和Yaffil數(shù)據(jù)庫服務(wù)器

• 支持所有InterBase數(shù)據(jù)類型

• 具有自動連接控制的斷開模型，用于脫機處理數(shù)據(jù)

• 用于檢測連接丟失并隱式重新執(zhí)行某些操作的本地故障轉(zhuǎn)移

• 所有類型的本地排序和過濾，包括計算和查找字段

• 使用TIBCQuery和TIBCTable組件自動更新數(shù)據(jù)

• Unicode和國家字符集支持

• InterBase Events支持

• 使用TIBCScript組件的高級腳本執(zhí)行功能

• 支持在SQL中使用宏

• 使用遷移向?qū)лp松從BDE和IBX遷移

• 允許用戶使用Delphi，C ++ Builder和Kylix專業(yè)版來開發(fā)客戶端/服務(wù)器應(yīng)用程序

• 包括年度IBDAC訂閱優(yōu)先支持

• 每個開發(fā)人員，每個團隊或每個站點的許可使用費

Components
IBDAC includes the following components:

• TIBCConnection - sets and controls connection to InterBase database
• TIBCTransaction - provides discrete transaction control over database connections
• TIBCQuery - uses SQL statements to retrieve data from InterBase table or tables, automatically generates missing INSERT, DELETE, UPDATE statements
• TIBCTable - lets you retrieve and update data in a single table without writing SQL statements
• TIBCStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter
• TIBCSQL - executes SQL statements and stored procedures, which do not return rowsets
• TIBCScript - executes sequence of SQL statements
• TIBCUpdateSQL - lets you tune update operations for a DataSet component
• TIBCDataSource - provides an interface between a IBDAC dataset components and data-aware controls on a form
• TIBCAlerter - transfers messages between connections
• TIBCMetaData - retrieves metadata on specified SQL object
• TIBCSQLMonitor - allows to monitor dynamic SQL executing in IBDAC-based applications
• TIBCConnectDialog - serves for entering username, password and server name
• TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search
• TVirtualTable - dataset stores data in memory
• IBCDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features
The following list describes the main features of InterBase Data Access Components.

• Direct access to server data. 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 InterBase, Firebird and Yaffil database servers
• Support for all InterBase data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly re-executing certain operations
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TIBCQuery and TIBCTable components
• Unicode and national charsets support
• InterBase Events support
• Advanced script execution functionality with TIBCScript component
• Support for using Macros in SQL
• Easy migration from BDE and IBX with Migration Wizard
• Lets you use Professional Edition of Delphi, C++Builder, and Kylix to develop client/server applications
• Includes annual IBDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site