Export (0) Print
Expand All
Expand Minimize

LIST Commands

Displays table or environment information without pausing the main Visual FoxPro or user-defined window. There are multiple versions of the syntax.


LIST [FIELDS FieldList] [Scope] [FOR lExpression1]
   [WHILE lExpression2] [OFF] [NOCONSOLE] [NOOPTIMIZE]
   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]]

LIST FILES [ON Drive] [LIKE FileSkeleton] 
   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]]

LIST MEMORY [LIKE FileSkeleton] [NOCONSOLE]
   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]]

LIST STATUS [NOCONSOLE] 
   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]]

LIST STRUCTURE [IN nWorkArea | cTableAlias] [NOCONSOLE]
   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]]

The LIST commands are identical to the DISPLAY commands except for the following differences:

  • LIST displays information without pausing, whereas DISPLAY displays the first screen of information and then pauses. For more information, see DISPLAY Command.

  • ADDITIVE clause appends to the end of the named file. If you omit ADDITIVE, the file is overwritten with the value of the expression.

  • The scope for LIST defaults to ALL records.

  • LIST does not display records flagged for deletion when SET DELETED is ON. For more information, see SET DELETED Command.

Community Additions

ADD
Show:
© 2014 Microsoft