use database
Specify a database against which the ensuing SQL action lines are to be applied.
| Name | Description | Type | Modifier |
|---|---|---|---|
| name | Name of the database connection (previously established via the connect database action). | String | None |
None
The following example illustrates the process of connecting to, and using a database from within a test. After creating a named connection string and using it to connect to the database, invoke use database to specify the active database to be used by the test.
variable driver host create connection string Northwind_conn_strg SQL Server lgdn15031-w7d01 port database name username >>> Northwind password others >>> Trusted_Connection=Yes connection string name connect database #Northwind_conn_strg Northwind_conn name use database Northwind_conn command result execute sql select ContactName from Customers where CustomerID='ABOUT' contactname_ds
- This action is generally invoked as part of a sequence of actions to allow the test to access a data source. (See Testing with databases for more information)
- This action supports the <ignore> modifier. If the string
<ignore>is present as the value of the argument, or the argument contains an expression that evaluates to<ignore>, the action is skipped during execution.
Tel:
Email: