Build field names list

Command groupFlag affectedReversibleExecute on clientPlatform(s)
FilesYESYESNOAll

Syntax

Build field names list
 
 ([
Clear list
][,
Full names
])
 
file-name

Options

Clear listIf specified,the command empties the current list,and defines it to have a single hash variable column,before executing
Full namesIf specified,names in the list are prefixed with their file class name

Description

This command builds a list of field names for the specified file class in the current list. You must specify the following columns in the current list.

Column 1 (Character) Column 2 (Character) Column 3 (Character)
Field name Field type and length Description; for index fields only

When you use the Clear list option you get column 1 only defined as #S5. With this option the command becomes reversible. The flag is cleared if the value of LIST.$linemax prevents a complete list from being built.

The Full names option creates a list in which the fields are prefixed with the file class name, for example, PO_DATE becomes FPORDERS.PO_DATE.

Example

# Build a list of the field names in the file class fAccounts

Set current list
 
lFieldList

Build field names list
 (
Clear list
,
Full names
)
 
fAccounts

 
# alternatively $makelist can be used

Do
 
$files
.
fAccounts
.
$objs.$makelist
(
$ref.$name
)
 
Returns 
lFieldList