You can connect to and work with databases by using methods and properties of the TestComplete
BDE program objects. To learn how to work with these objects, we recommend that you get acquainted with the following examples:
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.