Working With Databases Using ADO and BDE Objects

Applies to TestComplete 14.80, last modified on April 13, 2021

You can connect to and work with databases by using methods and properties of the TestComplete ADO and BDE program objects. To learn how to work with these objects, we recommend that you get acquainted with the following examples:

Note: The ADO object has the following specifics:

  • It can be used to execute only SQL queries (SELECT, UPDATE, INSERT, etc.), not SQLCMD scripts.

  • While retrieving Decimal values from a database, it converts them to the Currency type. Since the Currency type has a smaller size than the Decimal type has, an overflow error occurs if a Decimal value being retrieved is large and falls outside of the Currency type’s data range. You may get this error when retrieving large Decimal values (more than 14 significant digits). To avoid the error, you can work with the database by using Microsoft ADO components (see above).

To learn more about other ways of working with databases that are available in TestComplete, see Working With Databases.

See Also

Working With Databases
Using ADO Components
ADO Object
BDE Object

Highlight search results