You can connect to and work with databases by using methods and properties of the ADO object. To learn how to work with this object, we recommend that you get acquainted with the following examples:
In This Section
Notes:
-
The
ADOobject can be used to execute only SQL queries (SELECT, UPDATE, INSERT, etc.), not SQLCMD scripts. -
While retrieving Decimal values from a database, the
ADOobject 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.