Difference between revisions of "Data Attributes"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 55: | Line 55: | ||
− | The '''Default''' attribute is available in Form Section | + | The '''Default''' attribute is available in [[Field Attributes|Form Section Fields]], [[Advanced Canvas Control Attributes|Canvas Section Advanced Controls]] and [[Grid Column Attributes|Grid 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. | It specifies the default value for the field when a new record is added or the initial value of a memory variable data source. | ||
Line 139: | Line 139: | ||
==Inherit dictionary rules== | ==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. | + | [[Field Attributes|Form Section]] and [[Advanced Canvas Control Attributes|Canvas Section Advanced]] controls can 'inherit' the Data Dictionary rules. This populates the control's relevant attributes with the settings from the Data Dictionary. |
[[{{ns:file}}:section_inherit.png|450px|thumb|left|link=|Section: Inherit dictionary rules]] | [[{{ns:file}}:section_inherit.png|450px|thumb|left|link=|Section: Inherit dictionary rules]] | ||
Line 177: | Line 177: | ||
− | The '''Mandatory input''' attribute is available in Form Section and Canvas Section | + | The '''Mandatory input''' attribute is available in [[Field Attributes|Form Section Fields]] and [[Advanced Canvas Control Attributes|Canvas Section Advanced Controls]]. |
It specifies that the field cannot be empty. | It specifies that the field cannot be empty. | ||
Line 254: | Line 254: | ||
==Validation error message== | ==Validation error message== | ||
− | * Applies to Grid | + | * Applies to [[Grid Column Attributes|Grid Columns]]. For [[Field Attributes|Form Section Fields]] and [[Advanced Canvas Control Attributes|Canvas Section Advanced Controls]], see [[#Error message|Error message]] |
==Notes on Client Support== | ==Notes on Client Support== |
Revision as of 06:53, 18 May 2016
Under Construction
Contents
- 1 See Also
- 2 Anchor
- 3 Autosuggestions
- 4 Autosuggestion headers
- 5 Autosuggestion column to search
- 6 Background color
- 7 Choices
- 8 CommandButton Caption
- 9 CommandButton Icon image
- 10 Context Menu
- 11 Custom attributes
- 12 Data size
- 13 Data source
- 14 Default
- 15 Default search field
- 16 Dialog button
- 17 Dialog button delegate
- 18 Editable
- 19 Error message
- 20 Font
- 21 Foreground color
- 22 Get data mapping
- 23 Help topic
- 24 Hide search field indicator
- 25 Hyperlink
- 26 Inherit dictionary rules
- 27 Input mask
- 28 Input mask type
- 29 Mandatory input
- 30 Password input
- 31 Placeholder text
- 32 Recalculate
- 33 Relate on change
- 34 Render as a CommandButton
- 35 Return tabs
- 36 Search field
- 37 Search panel field
- 38 Set data mapping
- 39 Tab order
- 40 Text alignment
- 41 Tooltip
- 42 User selectable search field
- 43 Validation
- 44 Validation error message
- 45 Notes on Client Support
See Also
Autosuggestions, Choices, Colors, Data Mapping, Fonts, Formitem Appearance, Help Attributes, Input Masks, Instant Search
Anchor
Autosuggestions
- See Autosuggestions.
Autosuggestion headers
- See Autosuggestions.
Autosuggestion column to search
- See Autosuggestions.
Background color
- See Colors.
Choices
- See Choices.
CommandButton Caption
CommandButton Icon image
Context Menu
Custom attributes
Data size
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
The Default attribute is available in Form Section Fields, Canvas Section Advanced Controls and Grid 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.
Double-click the header of a column in a Grid Section to access the Column Attributes.
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.
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
Hide search field indicator
- See Instant Search.
Hyperlink
Inherit dictionary rules
Form Section and Canvas Section Advanced controls can 'inherit' the Data Dictionary rules. This populates the control's relevant attributes with the settings from the Data Dictionary.
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.
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
The Mandatory input attribute is available in Form Section Fields and Canvas Section Advanced Controls.
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.
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
Placeholder text
Recalculate
Relate on change
Render as a CommandButton
Return tabs
Search field
- See Instant Search.
Search panel field
Set data mapping
- See Data Mapping.
Tab order
Text alignment
Tooltip
User selectable search field
- See Instant Search.
Validation
Validation error message
- Applies to Grid Columns. For Form Section Fields and Canvas Section Advanced Controls, see Error message
Notes on Client Support
Attribute | Notes |
---|---|
Context Menu | Currently supported on the Desktop client only. |
Help topic | Currently supported on the Desktop client only. |
Tooltip | Currently supported on the Desktop client only. |