C5_CONTINUE

 CONTINUE
 Resume a pending LOCATE
------------------------------------------------------------------------------
 Syntax

     CONTINUE

 Description

     CONTINUE is a database command that searches from the current record
     position for the next record meeting the most recent LOCATE condition
     executed in the current work area.  It terminates when a match is found
     or end of file is encountered.  If CONTINUE is successful, the matching
     record becomes the current record and FOUND() returns true (.T.); if
     unsuccessful, FOUND() returns
     false (.F.).

     Each work area may have an active LOCATE condition.  In Clipper, a
     LOCATE condition remains pending until a new LOCATE condition is
     specified.  No other commands release the condition.

 Notes

     .  Scope and WHILE condition: Note that the scope and WHILE
        condition of the initial LOCATE are ignored; only the FOR condition
        is used with CONTINUE.  If you are using a LOCATE with a WHILE
        condition and want to continue the search for a matching record, use
        SKIP and then repeat the original LOCATE statement adding REST as the
        scope.

 Examples

     .  This example scans records in Sales.dbf for a particular
        salesman and displays a running total sales amounts:

        LOCAL nRunTotal := 0
        USE Sales NEW
        LOCATE FOR Sales->Salesman = "1002"
        DO WHILE FOUND()
           ? Sales->Salesname, nRunTotal += Sales->Amount
           CONTINUE
        ENDDO

     .  This example demonstrates how to continue if the pending
        LOCATE scope contains a WHILE condition:

        LOCAL nRunTotal := 0
        USE Sales INDEX Salesman NEW
        SEEK "1002"
        LOCATE REST WHILE Sales->Salesman = "1002";
              FOR Sales->Amount > 5000
        DO WHILE FOUND()
           ? Sales->Salesname, nRunTotal += Sales->Amount
           SKIP
           LOCATE REST WHILE Sales->Salesman = "1002";
              FOR Sales->Amount > 5000
        ENDDO

 Files   Library is CLIPPER.LIB.

See Also: EOF() FOUND() LOCATE SEEK

 

Advertisements

3 responses to “C5_CONTINUE

  1. Pingback: C5_LOCATE | Viva Clipper !

  2. Pingback: DB Commands | Viva Clipper !

  3. Pingback: C5 Commands | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.