The record data type

Composite data type. A collection of one or more scalar values (called fields) in fixed number and sequence.

There is no literal syntax specific to record-type values. You can instantiate record-type values with a single-row, multi-column table expression with the literal syntax pattern below. 

TABLE column-name1,...,column-namen
(field-value1,...,field-valuen;
field-value1,...,field-valuen)

Parameter Description
column-name (required) The string valeu name of the column which must be unique across the table expression.
field-value (required) A literal expression that instantiates a static value which can be any data type.

dataTypesSample.fls.xml

...
<declarations>
  <let id="sampleLet"
    shape="record"
    value='{SELECT 23 foo, 46 bar}'/>
</declarations>
...

Figure 271. This let element has a record-type value


Related links

The int data type   The recordset data type
Copyright © 2016 Mobilengine Corp. All rights reserved. version: 7.0.4.19927