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]]

Remarks

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.

See Also

Reference

LIST CONNECTIONS Command
LIST DATABASE Command
LIST DLLS Command
LIST OBJECTS Command
LIST PROCEDURES Command
LIST TABLES Command
LIST VIEWS Command

Other Resources

Commands (Visual FoxPro)
Language Reference (Visual FoxPro)