Skip to content

CGETSQL

The CGETSQL formula is used to retrieve a value from a CALUMO Editable Table based up the key and field name passed in as part of the function.

Syntax

CGETSQL (EditableTable, Key, ColumnName, DefaultValue, IsEditable)

Arguments

EditableTable

(Required)

Specify the Editable Table ID or Name to use as the base definition

Key

(Required)

Specify the key value from the table that this formula should use to get the data

ColumnName

(Required)

Specify the column/field name from the Editable Table for which to display the data from the record of the specified Key

DefaultValue

Specify the default value to use when a new record is created against this Editable Table.

IsEditable

Specify if this cell is editable or not. This setting can not override when the column is set as not updatable in the Editable Table definition.

Default value: TRUE

Usage Scenarios

This formula is used as a part of building an input form along with formula such as CREPORTSQLSELECTOR and CREPORTSQLPAGER