Click above to get retro games delivered to your door ever month!

  LIST             - List records to the console    
-------------------------------------------------------------------------------

  Syntax:

  LIST <exp list> [TO PRINTER] [TO FILE <xcFile>]
       [<scope>] [WHILE <lCondition>] [FOR <lCondition>] 
       [OFF] [NOOPTIMIZE]

  Arguments:

  <exp list> is the list of expressions to be evaluated and displayed
  for each record processed.

  TO PRINTER echoes output to the printer.

  TO FILE <xcFile> echoes output to the specified filename and can be
  specified either as a literal filename or as a character expression
  enclosed in parentheses.  If an extension is not specified, (.TXT) is
  added.

  <scope> is the portion of the current database file to LIST.  The default
  is ALL records.  The scope must be ALL to be optimized by Mach SIx.

  WHILE <lCondition> specifies the set of records meeting the condition from
  the current record until the condition fails.  Mach SIx does not support the
  WHILE condition.

  FOR <lCondition> specifies the conditional set of records to LIST within
  the given scope.  Mach SIx will optimize any FOR condition that contains one
  or more active index keys.

  OFF suppresses the display of record numbers.

  NOOPTIMIZE, preempts optimization and forces default Clipper processing.

  Description:

  LIST is a console command that sequentially accesses records in the
  current work area, displaying the results of one or more expressions for
  each record accessed.  The output is in tabular format with each column
  separated by a space.  LIST is identical to DISPLAY with the exception that
  its default scope is ALL rather than NEXT 1.

  When invoked, output is sent to the screen and optionally to the printer
  and/or a file.  To suppress output to the screen while printing or echoing
  output to a file, SET CONSOLE OFF before the LIST invocation.

  The LIST command may be optimized by specifying one or more active index
  keys in the FOR condition.  Note that Mach SIx will only optimize a LIST
  with a FOR condition and a scope of ALL.  WHILE conditions and alternate
  scopes cannot be optimized by Mach SIx.

  Notes:

  Interrupting LIST:  The Clipper guide suggests using a test for INKEY() in
  the FOR condition in order to interrupt LIST processing.  Because of the
  way Mach SIx parses and evaluates the FOR condition this technique is not
  recommended and might produce unexpected results.

  Printer margin: LIST honors the current SET MARGIN for output echoed to
  the printer.


  ---------------------------------| EXAMPLE |--------------------------------

  /*:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
  *  Demonstrates optimized LIST command                                    *
  *::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::*/

  #include "DBFSIX.CH"
  #include "MACHSIX.CH"

  USE Account VIA "DBFSIX"  // Structural index ACCOUNT.CDX opened
                            // automatically
  CLEAR SCREEN
  ? "Example of optimized LIST command."
  ?

  // Fully optimized display of records for accounts in Florida
  LIST AcctNo, Last, First, Balance FOR State = "FL"
  CLOSE ALL