In the JDBC and the Data Connection data sources, you can use the prepared properties to add variable values to database queries.
 |
To create a new prepared property, click
on the toolbar of prepared properties and specify the desired name and value. The value of the prepared property can be either constant or any other testing property.To use prepared properties in a query, specify the name of the desired prepared property with the leading colon symbol (
:).To delete the selected property from the list, select it and click
.
To use a dynamic test case property named code in the database request:
Create a prepared property and name its
country_code.Set its value to the following property expansion:
${#TestCase#property_name}In the SQL query, add a colon followed by the name of the prepared property.
SELECT city_name FROM city WHERE CountryCode = :country_code