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

  LOCATE:

  Syntax:

  LOCATE [<scope>] FOR <lCondition>
   [WHILE <lCondition>] [NOOPTIMIZE]

  <scope> is the portion of the current database file in which to
  perform a LOCATE. The default scope is ALL records. Mach SIx supports
  the ALL scope only.

  FOR <lCondition> specifies the next record to LOCATE. Mach SIx will
  optimize any FOR condition that contains one or more active index keys.

  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.

  NOOPTIMIZE, preempts optimization and forces default Clipper
  processing.

  Description: 

  LOCATE is a database command that searches from the top of the scope for
  the first record that matches the specified condition(s). It stops when
  a match is found or the end of the scope is reached.

  If LOCATE is successful, the matching record becomes the current record
  and FOUND() returns true (.T.).  If it is unsuccessful, FOUND() returns
  false (.F.). In this case the record pointer will be at eof() if the
  controlling scope is the default ALL. If the controlling scope is other
  than the default, the record pointer will be at the bottom of the scope.

  Each work area can have its own LOCATE condition.  The condition remains
  active until you execute another LOCATE command in that work area or the
  application terminates.

  LOCATE works with CONTINUE.  Once a LOCATE has been issued, you can
  resume the search from the current record pointer position with
  CONTINUE.


  Example: 

  #include "SIXCDX.CH"
  #include "MACHSIX.CH"

  USE claims
  INDEX on amt_paid TAG amt_paid
  INDEX on region TAG region

  // show claims greater than 500,000 by region

  LOCATE for AMT_PAID >= 500000
  DO WHILE FOUND()
    ? "Region: ", region, " Amount: ", amt_paid
    CONTINUE
  ENDDO