Skip to main content

Prepared Properties

In the JDBC and the Data Connection data sources, you can use the prepared properties to add variable values to database queries.

The Prepared Properties editor

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 .

Example

To use a dynamic test case property named code in the database request:

The sample prepared property

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
```

See Also

In this section: