Export (0) Print
Expand All
Expand Minimize
5 out of 9 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.