C5_DBCLEARINDEX

 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()



One response to “C5_DBCLEARINDEX

  1. Pingback: C5_SET INDEX | 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.