Storage Format Options

Optional.  Storage format options specify a field’s storage format, typically for numbers and dates.

Field Validation Type

Formatting Options

Boolean

If the underlying database type is string-based, you can specify how Boolean values are written to the database.  The syntax is the same as Display Format.  This means that you can display values one way, but write them to the database another way.  For example, you could display True as "Yes" but save it in the database as "T".

If the underlying database type is numeric (i.e. bigint, decimal, etc.), the user does not have control over the storage format.  True/False values are stored as the numbers 1 and 0.

By default, the Boolean column class recognizes the following set of True and False values:

            True:     "True", "T", "Yes", "Y", "1"
            False:   "False", "F", "No", "N", "0"

Credit Card Expiration Date
Currency
Date
Decimal Number
Number
Percentage

The formats for Iron Speed Designer’s numeric and date field validation types must be valid .NET format strings.  The syntax is the same as Display Format.  Both standard and custom format strings are permitted, as long as they are considered valid by .NET, as defined in the Microsoft .NET format string documentation:

 

This information is quite extensive.

US State

Special formatting codes are available for this field validation type, as explained in US State Format Strings.

See Also

Setting Database Field Properties

.NET formatting types