LIST Commands

  • Article

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)