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.