InterBase數據訪問組件(IBDAC)是一個組件庫,提供對InterBase、Firebird和Yaffil數據庫服務器的訪問。 IBDAC直接使用InterBase客戶端連接到服務器。 IBDAC旨在幫助程序員開發更快、更清晰的InterBase數據庫應用程序。
IBDAC是標準InterBase連接解決方案的完全替代品。它提供了InterBase Express組件和Borland數據庫引擎的有效替代方案去訪問InterBase。
InterBase Data Access Components (IBDAC) is a library of components that provides access to InterBase, Firebird and Yaffil database servers. IBDAC uses the InterBase client directly to connect to the server. The IBDAC library is designed to help programmers develop faster and cleaner InterBase database applications.
IBDAC is a complete replacement for standard InterBase connectivity solutions. It presents an efficient alternative to InterBase Express Components and the Borland Database Engine for access to InterBase.
組件
IBDAC包括以下組件:
TIBCConnection - 設置和控制與InterBase數據庫的連接
TIBCTransaction - 提供對數據庫連接的離散事務控制
TIBCQuery - 使用SQL語句從InterBase表或表中檢索數據,自動生成缺少的INSERT、DELETE、UPDATE語句
TIBCTable - 允許用戶在單個表中檢索和更新數據,而無需編寫SQL語句
TIBCStoredProc - 執行存儲過程和函數,允許編輯作為參數返回的游標數據
TIBCSQL - 執行不返回行集的SQL語句和存儲過程
TIBCScript - 執行SQL語句序列
TIBCUpdateSQL - 允許用戶調整DataSet組件的更新操作
TIBCDataSource - 在表單上提供IBDAC數據集組件和數據感知控件之間的接口
TIBCAlerter - 在連接之間傳輸消息
TIBCMetaData - 檢索指定SQL對象上的元數據
TIBCSQLMonitor - 允許監視在基于IBDAC的應用程序中執行的動態SQL
TIBCConnectDialog - 用于輸入用戶名、密碼和服務器名稱
TCRDBGrid - 擴展了TDBGrid功能,提供了對過濾器和增量搜索的可視訪問
TVirtualTable - 數據集將數據存儲在內存中
IBCDataAdapter - .NET組件,使用TDataSet作為數據源,用于檢索和保存數據到System.Data.DataSet
TCRBatchMove - 在所有類型的TDataSet后代之間傳輸數據
主要特點
以下列表描述了InterBase數據訪問組件的主要功能。
直接訪問服務器數據。不需要安裝其他數據提供程序層(例如BDE和ODBC)
提供VCL、VCL.NET和CLX版本的庫
完全支持最新版本的InterBase、Firebird和Yaffil數據庫服務器
支持所有InterBase數據類型
具有自動連接控制的斷開模型,用于脫機處理數據
用于檢測連接丟失并隱式重新執行某些操作的本地故障轉移
所有類型的本地排序和過濾,包括計算和查找字段
使用TIBCQuery和TIBCTable組件自動更新數據
Unicode和國家字符集支持
InterBase Events支持
使用TIBCScript組件的高級腳本執行功能
支持在SQL中使用宏
使用遷移向導輕松從BDE和IBX遷移
允許用戶使用Delphi,C ++ Builder和Kylix專業版來開發客戶端/服務器應用程序
包括年度IBDAC訂閱優先支持
每個開發人員,每個團隊或每個站點的許可使用費
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