Using a SELECT statement in a value
Use select statement in the Value field
When we want to describe a dataset using SQL, we write a SELECT statement.. The SELECT statement contains a complete description of the dataset that we want to get from the database.
In the Edit templates window, we enter the desired SELECT statement into the Value field in the lower section Set object values.
We have defined a simple SELECT statement for the item field:
When using the template, the program will input the result of the SELECT statement to the item criterion:
In the Items register, we have item LARA3 with the name TENT LARA 3:
