dataType

The dataType property specifies a string that identifies an EGL primitive data type for the field. The property is meaningful only on a field used to create selection criteria for an SQL statement. In this case, an entire openUI statement is bound to a STRING variable, which contains the WHERE clause for the SQL SELECT statement. The following example shows this binding:
selectStatement STRING;

openUI myCustomerSQLRecord { isConstruct = YES }
   bind selectStatement
end

The individual fields in the record for the openUI statement are not bound to variables. For this reason, EGL does not have a type for those fields and cannot verify that user input is compatible with the SQL columns associated with the fields by means of the SQLColumnName property (see sqlColumnName). For more about the isConstruct property, which determines whether the openUI statement is used for a selection statement, see openUI.

The property is a STRING type.

Specify the NUMBER type if the user can enter floating point values; if the SQL column requires whole numbers, use an integer type such as INT.

The empty string is the default value for this property. It cannot be updated at run time.

Compatibility

Table 1. Support for dataType property
Data item JSF handler VGUI record Console UI Text Form Java™ Text Form COBOL Print Form Java Print Form COBOL
Yes No No Yes No No No No

Feedback