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()
Pingback: C5_SET INDEX | Viva Clipper !