The recordset data type

A collection of one or more record-type values.

You can instantiate a recordset-type value with a multi-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

...
<textview
  text='{SELECT GROUP_CONCAT(f.yolo, ".")
        FROM (TABLE yolo ("foo"; "bar"; "baz")) f}'/>
...
The textbox displays the values of a single-column, multi-row table literal, concatenated into a string

Figure 272. The textbox displays the values of a single-column, multi-row table literal, concatenated into a string


Related links

The record data type   The rowset data type
Copyright © 2016 Mobilengine Corp. All rights reserved. version: 7.0.4.19927