If your applications use Microsoft Active Data Objects (ADO) to manage databases and tables, you can have the same access from your TestComplete scripts. For instance, by querying the database engine directly, you can check whether your New Client dialog actually updates the database, as opposed to leaving the new record in a local buffer.
To access the ADO interface from scripts, make sure the following requirements are met:
-
The ADO Support plugin is enabled in TestComplete. This plugin is installed and enabled during TestComplete installation automatically regardless of the TestComplete modules you use.
To check whether the plugin is active, open the File | Install Extension dialog.
If the plugin is not available, re-install TestComplete.
The ADO Support plugin fully supports ADO objects created using either Microsoft or Borland applications. It supplies its own interfaces for accessing those objects, and these interfaces are modeled after Borland’s VCL objects for ADO access, rather than on Microsoft’s VC++ and VB ADO interfaces (Connection, Command, Recordset, Parameter, Error and Property). The plugin, however, does provide certain methods that return the “native” ADO Connection, Command and Recordset objects. (See ADO Object.)
As for VCL ADO support, the ADO Support plugin exports several interfaces that are analogues to VCL ADO objects:
| Interfaces in ADO Support Plugin | VCL Analogue |
|---|---|
IAQAADOConnection |
TADOConnection |
IAQAADOCommand |
TADOCommand |
IAQAADODataset |
TADODataset |
IAQACustomADODataset |
TCustomADODataset |
IAQAADOTable |
TADOTable |
IAQAADOQuery |
TADOQuery |
IAQAADOStoredProc |
TADOStoredProc |
For detailed information on how to get access to these interfaces, see ADO Object. These interfaces implement the same methods and properties as their VCL analogues, using the same names. For more information, see VCL documentation on ADODB classes.
For a description of ADO objects and their functionality, see the MSDN article on ADO objects.
The ADO interfaces require that the Microsoft Data Access Components, ver. 2.1 or later, be installed on the computer. These can be downloaded from http://msdn2.microsoft.com/en-us/data/aa937730.aspx.
See Also
ADO Object
Working With Databases
BDE Support - Requirements
Installing Extensions