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