Previous Next

ADD-COLUMNS-FROM( ) method
Creates a browse column for each field found in the specified buffer or table. If a field is found that already has a corresponding browse column created, it is ignored. This method can be used only after the browse’s query attribute has been set.
Return type:
Applies to:
 
Syntax 
ADD-COLUMNS-FROM ( buffer-handle | table-name-exp [ , except-list ] )
buffer-handle
The handle of a buffer associated with the browse’s query.
table-name-exp
The name of a table associated with the browse’s query.
except-list
An expression that evaluates to a comma-separated list of field names to be excluded from the browse. Do not include the table name with these field names, and do not include spaces between field names.
The following is an example of adding browse columns from the Invoice table, excluding the fields, Amount and Total-Paid:
 
DEFINE VARIABLE ExcList AS CHARACTER INITIAL "Amount,Total-Paid".
. . .
AddCol = BrwsHndl:ADD-COLUMNS-FROM("invoice", ExcList).
The ADD-COLUMNS-FROM( ) method may be used on a static browse as well as a dynamic browse. When used on a static browse, the browse will become a NO-ASSIGN browse (you must make the database updates).
A dynamic browse column’s validation expression is restricted. It may not contain a CAN-FIND function. To reference the field, the FRAME-VALUE function must be used.
To create a combo-box or toggle-box browse column for a buffer-field, specify the widget type in the buffer-field’s VIEW-AS attribute. A buffer-field’s VIEW-AS attribute setting remains in effect for subsequent columns created for that buffer-field, until you change the attribute setting, and changing the attribute setting does not affect previously created columns. (The VIEW-AS attribute has no effect in character mode.)

Previous Next
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.