FieldAttributes

Overview

Sets the formatting of a field.

The properties of qFieldAttributes and the formatting mechanism are described below.

Name	Description	Type
qType	Type of the field. Default is U.	One of: • U for UNKNOWN type. • A for ASCII; Numeric fields values contain only standard ASCII characters. • I for INTEGER; Numeric fields values are shown as integer numbers. • R for REAL; Numeric fields values are shown as real numbers. • F for FIX; Numeric fields values are shown as numbers with a fix number of decimals. • M for MONEY; Numeric fields values are shown as in the money format. • D for DATE; Numeric fields values are shown as dates. • T for TIME; Numeric fields values are shown as times. • TS TIMESTAMP; Numeric fields values are shown as time stamps. • IV for INTERVAL; Numeric fields values are shown as intervals.
qnDec	Number of decimals. Default is 10.	Integer between 0 and 15.
qUseThou	Defines whether or not a thousands separator must be used. Default is 0.	One of: 0 for false 1 for true
qFmt	Defines the format pattern that applies to qText. Is used in connection to the type of the field (parameter qType). For more information, see Struct FieldAttributes. Example: YYYY-MM-DD for a date	String
qDec	Defines the decimal separator. Example: .	String
qThou	Defines the thousand separator (if any). Is used if qUseThou is set to 1. Example: ,	String

The formatting mechanism depends on the type set in qType, as shown below:

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

The following applies:

If a format pattern is defined in qFmt, the formatting is as defined in qFmt.
If qFmt is empty, the formatting is defined by the number interpretation variables included at the top of the script (TimeFormat, DateFormat, TimeStampFormat).
The properties qDec, qThou, qnDec, qUseThou are not used.

The following applies:

If a format pattern is defined in qFmt, the engine looks at the values set in qDec and qThou. If these properties are not defined, the formatting mechanism uses the number interpretation variables included at the top of the script (DecimalSep and ThousandSep).
If no format pattern is defined in qFmt, no formatting is applied. The properties qDec, qThou, qnDec, qUseThou and the number interpretation variables defined in the script are not used .

The following applies:

If a format pattern is defined in qFmt, the engine looks at the values set in qDec and qThou. If these properties are not defined, the engine uses the number interpretation variables included at the top of the script (DecimalSep and ThousandSep).
If no format pattern is defined in qFmt, and if the value is almost an integer value (for example, 14,000012), the value is formatted as an integer. The properties qDec, qThou, qnDec, qUseThou are not used.
If no format pattern is defined in qFmt, and if qnDec is defined and not 0, the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.
If no format pattern is defined in qFmt, and if qnDec is 0, the number of decimals is 14 and the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

The following applies:

If a format pattern is defined in qFmt, the engine looks at the values set in qDec and qThou. If these properties are not defined, the engine uses the number interpretation variables included at the top of the script (DecimalSep and ThousandSep).
If no format pattern is defined in qFmt, the properties qDec and qnDec are used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

The following applies:

If a format pattern is defined in qFmt, the engine looks at the values set in qDec and qThou. If these properties are not defined, the engine uses the number interpretation variables included at the top of any script (MoneyDecimalSep and MoneyThousandSep).
If no format pattern is defined in qFmt, the engine uses the number interpretation variables included at the top of the script (MoneyDecimalSep and MoneyThousandSep).

No formatting, qFmt is ignored.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!