Field Properties

Just like tables, all the fields in C/SIDE have a number of properties that determine their behavior. When you create a field, C/SIDE automatically suggests a number of default values for these properties. Depending on the purpose of the field, you will sometimes want to change these default values.

C/SIDE contains the following field properties. The first table list the properties that are common to most field types.

Property name	Description
Field No. Property	Assigns a unique numeric ID to this field.
Name Property	Specifies the name of the field.
Caption Property	Specifies the text used to identify a control based on the field.
CaptionML Property	Specifies the text that is used to identify a control or other object in the user interface. The CaptionML property is multilanguage enabled and can contain a list of text in different languages. The text that is used is selected according to the current language setting of the user.
CaptionClass Property	Controls the caption that is used in the label of a field in a database table or in the label of a control on a form.
Description Property	Includes an optional description of the field. This description is for internal purposes only and is not visible to the end user.
Data Type Property	Specifies the data type of a table field.
Enabled Property	Determines whether the field is enabled.

A field may have additional properties, depending on its data type. The following table lists properties that apply to various field types.

Property Name	Description
DataLength Property	Specifies the maximum length of the data stored in a code or text field.
InitValue Property	Defines an initial value for a field.
FieldClass Property	Define the class for a field. That is, specifies whether it is a normal field, a FlowField, or a FlowFilter field.
CalcFormula Property	Defines a formula used by a FlowField.
AltSearchField Property	Defines an alternative search field.
DecimalPlaces Property	Sets the number of decimal places shown to the user. This property also performs validation of whether user input conforms to this setting.
Editable Property	Determines whether a field can be edited.
NotBlank Property	Forces the user to make a non-blank entry in this field.
BlankNumbers Property	Determines whether a range of numbers will be set to blank as they are formatted.
Numeric Property	Forces the user to enter numbers in this field.
CharAllowed Property	Sets the characters you will allow the user to enter in this field.
DateFormula Property	Validates the syntax of a date expression entered by the user.
Standard day/time unit Property	Specifies the unit of measure that is used when you enter data into Duration fields.
MinValue Property	Sets the minimum value for the contents of a field.
MaxValue Property	Sets the maximum value for the contents of a field.
Title Property	Adds a title to a field. The first letter in each word is capitalized.
ValuesAllowed Property	Specifies the values you want to allow in the field. Can be specified either as a range or as distinct values, or as a combination of these.
AutoIncrement Property	Specifies whether each field value is automatically given a new number that is greater than the number given to the previous value.
TableRelation Property	Defines relationships to other tables. For more information, see Setting Relationships Between Tables.
ValidateTableRelation Property	Indicates whether a table relationship is validated.
TestTableRelation Property	Indicates whether the field is included in table relationship tests.
TableIDExpr Property	Specifies the ID of the table to which you want to apply a table filter.
BlankZero Property	Determines whether the fields appears blank if the value is 0 (zero) or FALSE.
DataLength Property	Defines the length of a data field.
OptionString Property	Defines an option string (a comma-separated string of options). The maximum size is 1000 characters.
ClosingDates Property	Determines whether closing dates are allowed.
AutoFormatType Property	Determines how data is formatted.
AutoFormatExpr Property	Determines how data is formatted.
SignDisplacement Property	Shifts negative values to the right for display purposes.
SQL Data Type Property	Specifies the data type you want to allow in a code field. This property applies to code fields in the SQL Server Option for Microsoft Dynamics NAV.
ClearOnLookup Property	Specifies whether the current contents of the field are deleted before the value the user selects via the lookup is added.
SubType Property	Defines the subtype of a BLOB field, for example a Bitmap or a Memo.
Compressed Property	Specifies whether a BLOB is compressed. This property only applies to BLOB fields and only on the SQL Server Option.
OptionCaption Property	Defines the text string options that are displayed to the user.
OptionCaptionML Property	Sets the strings that are displayed to the user for selecting an option. The OptionCaptionML property is only used if the field has an OptionString property. The OptionString property contains the set of values that are acceptable choices, and it is one of these values that will be saved in the database or used in C/AL code.

See Also

Reference