Value Expression

A value expression takes one of the following general forms:
General form
Description
expression
#
expression
pick out a particular repetition
expression
.
column
find a value in a column of a lookup table
or it is simply one of:
literal text (double-quoted)
literal number
literal boolean (true/false)
db_ parameter
variable

Example 1

Consider a repeated variable
MultiBorrowerLoan
having values
10
,
11
and
12
.
Expression
Value
MultiBorrowerLoan # 1
10
MultiBorrowerLoan # 2
11
MultiBorrowerLoan # 3
12

Example 2

Consider the lookup tables of Select expression and a variable
EmpNum
having the value
"B3"
.
Expression
Value
EmpNum . 'Employee Name'
"Mrs Bo C"
EmpNum . Office
"Boston"
EmpNum . Office . Address
"10 Times Square, Boston"