Language Reference Guide : 4. System Classes : CellAttribute Class : FormatString Attribute
 
Share this page                  
FormatString Attribute
Data Type: varchar(256)
4GL Access: RW
The FormatString attribute contains the format string for an entry field used as a table field cell.
Valid formats vary, depending on the field's data type. If this attribute is not set, OpenROAD uses the data type's default format. Some examples are:
field(salary).FormatString = '"$$$,$$$,$$$.nn"';
field(salary).FormatString = 'f10.2';
field(purchase_date).FormatString = 'd"Feb 3, 1901"';
field(name).FormatString = 'Qrrrrrr';
For valid formats for this attribute, see the Workbench User Guide. For more information about numeric formats, see "format specifications" in the Ingres 9.3 Character-based Querying and Reporting Tools User Guide.