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:

LOGICAL

Applies to:

BROWSE widget

 

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.)