skip to main content
OpenEdge Development: ADM Reference
Data Objects and Their Methods and Properties : Column properties for query objects
 
Column properties for query objects
There are a number of column properties available for which you can obtain and set (write) field values. All of these properties can be read and some of them can be set. To read and set column properties, you use the following prefixes with the specific column property:
*Column — Use to read the value of a specific column property. For example, if you want to read the value of the ColumnLabel property, you would specify ColumnColumnLabel. This would return the label of the column you specify. To obtain the data type for a specific column property, you would specify ColumnDataType. This would return the data type of the specified column.
*Assign — Use to set the value of a specific column property. For example, if you want to set the label value for a specific column, you specify assignColumnColumnLabel. This would set the label value for the column you specify. To set a value for the column format, you would specify assignColumnFormat.
For additional information, see OpenEdge Development: Progress Dynamics Basic Development and OpenEdge Development: Progress Dynamics Advanced Development.
Table 5–1 lists the column properties for query objects, provides a brief description of each property, indicates whether the property can be read or set (write), and lists the data type for each property.
 
Table 5–1: Column properties for query objects
Column property
Description
Read
Write
Data type
ColumnLabel
Label of the specified column.
Yes
Yes
CHARACTER
DataType
Data type of the specified column
Yes
No
CHARACTER
DbColumn
Qualified database name (DatabaseName.TableName.
FieldName) mapped to the RowObject column identified by pcColumn
Yes
No
CHARACTER
DefaultValue
The OpenEdge help text of the specified column
Yes
No
CHARACTER
Extent
Extent of the specified RowObject column
Yes
No
INTEGER
Format
Format of the specified RowObject column.
Yes
Yes
CHARACTER
Handle
Handle of the specified RowObject column
Yes
No
HANDLE
Help
Help text for the specified RowObject column
Yes
Yes
CHARACTER
Initial
Initial value for a specified field as a character string with the field FORMAT applied
Yes
No
CHARACTER
Label
Label for the specified column
Yes
No
CHARACTER
LongCharValue
The LONGCHAR value of the specified column in the DataView DataTable buffer
Yes
No
LONGCHAR
Modified
Indicates whether or not a specified RowObject field has been modified. TRUE if modified, FALSE if not modified
Yes
No
LOGICAL
Name
The external unique name of the specified column
Yes
No
CHARACTER
PrivateData
Private Data property of the specified column
Yes
Yes
CHARACTER
QuerySelection
CHR(1)-separated string with all operators and values, but no field names, that have been added to the Query for this column
Yes
No
CHARACTER
ReadOnly
Identifies whether or not the specified column is in the list of columns that you can update. TRUE, if the column is in the list and FALSE, if not in the list
Yes
No
LOGICAL
StringValue
String Value of the specified column in the SmartDataObject RowObject buffer
Yes
No
CHARACTER
Table
Database table name of the specified column
Yes
No
CHARACTER
ValExp
Validation expression for the specified column in a RowObject temp-table
Yes
Yes
CHARACTER
ValMsg
Validation message text for the specified column of the SmartDataObjects RowObject temp-table
Yes
Yes
CHARACTER
Value
Raw (unformatted) character value of the specified field in a RowObject temp-table
Yes
No
CHARACTER
Width
Width in character units of the specified column of the SmartDataObjects RowObject temp-table
Yes
No
DECIMAL