6. Defining Frames with Visual Queries : Using Expressions in Frame Definitions
 
Share this page                  
Using Expressions in Frame Definitions
When you are defining frames, you can specify a value in the form of an expression to:
Assign values to columns on Append frames
Specify query restrictions on Browse and Update frames
Pass parameters between frames
(The syntax for parameters can differ from the syntax described in this section. Parameters are discussed in Passing Parameters Between Frames.)
The following table describes the types of expressions that you can use in Vision frame definitions.
Expression
Examples
A numeric or string constant
4
7.6
'NE'
'today'
A simple field
:part_no
A table-field column
:detailtbl.name
An arithmetic expression using any of these operators:
+
-
*
/
**
:salary*1.1
(110% of the value of the Salary field)
:order_no+1
(1 greater than the value of the order number field)
A logical expression using any of these comparison operators:
= ,!=,<>,^=,<,<=,>,>=
AND,OR,IS NULL,
IS NOT NULL,LIKE, NOT LIKE,IN,NOT IN
You can use logical expressions with Browse and Update frames only
>2 * :total
(greater than twice the value of the Total field)
!= 'Jones'
(retrieves all values except 'Jones')
 
IN (1,2,3)
IN ('NW','SE')