Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CA-Clipper 5.2 . The Guide To CA-Clippe - <b>dbclearindex()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 DBCLEARINDEX()
 Close all indexes for the current work area
------------------------------------------------------------------------------
 Syntax

     DBCLEARINDEX() --> NIL

 Returns

     DBCLEARINDEX() always returns NIL.

 Description

     DBCLEARINDEX() closes any active indexes for the current work area.  Any
     pending index updates are written and the index files are closed.

     DBCLEARINDEX() performs the same function as the standard SET INDEX
     command with no indexes specified.  For more information, refer to the
     SET INDEX command.

 Examples

     .  The following example clears index files if any are set:

        cLast := "Winston"
        DBUSEAREA( .T., "DBFNTX", "Sales", "Sales", .T. )
        DBSETINDEX( "FIRSTNAM" )
        DBSETINDEX( "LASTNAME" )
        //
        IF INDEXORD() > 0             // is there an index?
           DBCLEARINDEX()             // clear index files
        ELSE
           COPY TO FILE TEMP SDF      // copy to SDF in natural
        ENDIF                         // order

 Files:  Library is CLIPPER.LIB.

See Also: DBREINDEX() DBSETINDEX() DBSETORDER() SET INDEX

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson