Difference between revisions of "Data Attributes"

Revision as of 07:26, 3 May 2016

Under Construction

See Also

Autosuggestions, Choices, Colors, Data Mapping, Fonts, Formitem Appearance, Help Attributes, Input Masks, Instant Search

Autosuggestions

Autosuggestions

• See Autosuggestions.

Autosuggestion headers

• See Autosuggestions.

Autosuggestion column to search

• See Autosuggestions.

Background color

• See Colors.

Choices

Choices

• See Choices.

CommandButton Caption

CommandButton Icon image

Context Menu

• See Help Attributes: Context Menu.

Custom attributes

Data size

• See Formitem Appearance.

Data source

The field or memory variable the control is bound to.

For a field, this should be in the format tablename.fieldname:

customers.customerid

For memory variables, use the 'm.' prefix:

m.cMemvar1

Default

Default

The Default attribute is available in Form Section and Canvas Section fields and Grid Section columns.

It specifies the default value for the field when a new record is added or the initial value of a memory variable data source.

Here the orders.orderdate is populated with the system date when a new record is added.

Default

Double-click the header of a column in a Grid Section to access the Column Attributes.

Default

Here again the orders.orderdate is populated with the system date when a new record is added.

A Default has also been set on the orders.orderid field using the SEQNO() function to generate a unique sequential number.

The orders.customerid field automatically inherits the current customers.customerid value due to the Relationship Builder relation set between the customers Form Section and the orders Grid Section (key: customerid).

Data Dictionary: Default

The Default attribute corresponds to the Default Column Constraint stored in the table's Data Dictionary.

Modify a Column: Default

The Default Column Constraint can be set in the Create a Column and Modify a Column dialogs in the Data Workspace and Page Builder.

It can also be specified in the CREATE TABLE and ALTER TABLE commands.

// Mandatory
ALTER TABLE "orders" MODIFY CONSTRAINT ORDERDATE SET DEFAULT date()

• See Inherit dictionary rules for enabling dictionary inheritance.

Default search field

• See Instant Search.

Dialog button

Dialog button delegate

Editable

Error message

Font

• See Fonts.

Foreground color

• See Colors.

Get data mapping

• See Data Mapping.

Help topic

• See Help Attributes: Help table.

Hide search field indicator

• See Instant Search.

Hyperlink

Inherit dictionary rules

Form Section and Canvas Section controls can 'inherit' the Data Dictionary rules. This populates the control's relevant attributes with the settings from the Data Dictionary.

Section: Inherit dictionary rules

By default, controls have the Inherit dictionary rules attribute set to True, but the containing Form and Canvas Sections have the attribute set to False.

To enable dictionary inheritance for all the controls in a Section, set the Section's attribute to True.

Field: Inherit dictionary rules

The attributes of the controls will be populated with the dictionary settings (save and reload the App).

Inherit dictionary rules can then be disabled for individual controls as required.

Remember, enabling Inherit dictionary rules for the control has no effect unless Inherit dictionary rules for the control's containing Section is enabled.

Input mask

• See Input Masks.

Input mask type

• See Input Masks.

Mandatory input

Mandatory input

The Mandatory input attribute is available in Form Section and Canvas Section fields.

It specifies that the field cannot be empty.

Attempting to save a record without entering non-empty data in a field with the Mandatory input attribute set returns an error message and the record is not saved.

Note: 0 is considered an empty numeric value.

Data Dictionary: Not Null

The Mandatory input attribute corresponds to the Not Null Column Constraint stored in the table's Data Dictionary.

Modify a Column: Mandatory / Not Null

The Mandatory / Not Null Column Constraint can be set in the Create a Column and Modify a Column dialogs in the Data Workspace and Page Builder.

It can also be specified in the CREATE TABLE and ALTER TABLE commands.

// Mandatory
ALTER TABLE "customers" MODIFY CONSTRAINT CUSTOMERID SET NOT NULL
// Not Mandatory
ALTER TABLE "customers" MODIFY CONSTRAINT CUSTOMERID SET NULL

• See Inherit dictionary rules above for enabling dictionary inheritance.

Password input

• See Input Masks: Password input.

Placeholder text

• See Input Masks: Placeholder text.

Recalculate

Relate on change

Render as a CommandButton

Return tabs

Search field

• See Instant Search.

Search panel field

• See Section Search Panels.

Set data mapping

• See Data Mapping.

Text alignment

Tooltip

• See Help Attributes: Tooltips.

User selectable search field

• See Instant Search.

Validation

Notes on Client Support