Underlying Type property

Use the Underlying Type property to specify the Windows client data type for a component.

Setting Description
CHAR Text or character
DATE Date and time
CURRENCY Amount of money
I1 One-byte integer
I2 Two-byte integer
I4 Four-byte integer
R4 Four-byte floating point
R8 Eight-byte floating point
DECIMAL Fixed decimal.

Related component properties: Length and Decimal Point Position

BINARY The BLOB (binary large object) type in SQL Server databases supports images, sounds, multimedia, and other application file types.
NUMSORTCHAR A numeric or alphanumeric string that is padded for the purpose of proper numeric sorting.

Windows client uses the Underlying Type property to determine how to validate and present data in a component.

A component automatically assumes the data type of the IDO property to which it is bound. Data type can be inherited or overridden at any point in the WinStudio inheritance hierarchy. You can override a character string type, for example, with the DATE data type so that date or time validation is imposed on component values. You can reduce the precision of numeric values of a component by specifying a data type with lower precision than that of the type returned by the IDO.

A component defaults to CHAR data with an unlimited number of characters.