Extra Query Example 1: Dynamic Background Color Change
Prices over 1600 should be highlighted in red. Otherwise the Price text box should have a blue background.
Insert an Extra Query into the info box, and set the following properties for it:
SQL Statement: price > 1600
Yes Action Variables.price.background('red')
No Action Variables.price.background('blue')
Alternatively, you can set the Yes Action and No Action properties using the Object Activator. In this case, do not use the Client property. Select the data control as a part of each of the method calls.
When you insert an extra query, a column control with prompt 'x' is automatically displayed for its outcome. In this case, you want to make this control non-displayed.