r.(x,...)

Read(3166) Label: record, compute, expression,

Description:

Compute expressions against a record and return result of the last one.

Syntax:

r.(x,…)

Note:

The function computes expression x,… against record r, and return result of the last one.

Parameter:

r

A record

x,…

An expression, which is generally a field name or a legal expression that is composed of field names; use "~" to reference the current record

Return value:

The computation of x

Example:

 

A

 

1

=[[12,23]].new(~(1):col1,~(2):col2)

2

=A1(1).(col2+1)

24

3

=demo.query("select EID,NAME,HIREDATE,SALARY from employee")

 

4

=A3(1).(Hage=age(HIREDATE),if(Hage>10,SALARY+3000,SALARY+1000))

10000; return result of computing the last expression as there are multiple expressions.