[<<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:

        cFirst := "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: DBCREATEIND() DBREINDEX() DBSETINDEX() DBSETORDER()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson