On the Select a Data Source Type page of the Checkpoint wizard, you select the source of the data the Database Table checkpoint will verify:
-
Click Table to retrieve data from a database’s table.
Select the name of the desired table.
-
Click View to retrieve data from a database’s view or query.
Select the name of the desired view.
-
Click Custom query to specify an SQL query that TestComplete will use to retrieve data from the database.
You can enter query manually. You can also click Design and build the query in the ensuing SQL Designer.
When you click Next to continue, TestComplete will attempt to retrieve information on the fields that the table, view or query contains. If this attempt fails, TestComplete will display the error description returned by the database engine.
In some cases, the cause of the error is that the table or query name does not match the rules adopted by the database engine. For instance, the names of Microsoft SQL Server or Microsoft Access tables and queries may contain spaces and this is different from the rules adopted by classic SQL. So, you may need to change the name in order for TestComplete to be able to retrieve data from the table or query. For SQL Server or Access tables and queries, enclose the table (or query) name in brackets, for example, use [My Query Name] instead of My Query Name.
See Also
Checkpoint Wizard - Configure Database Table Checkpoint
Creating Database Checkpoints
About Checkpoints
About DBTables Collection