Closes various file types.
Syntax
CLOSE
[ALL | ALTERNATE | DATABASES [ALL] | DEBUGGER
| FORMAT | INDEXES | PROCEDURE | TABLES [ALL]]
Arguments
ALL
Closes all open databases, tables, and indexes in all work areas and selects work area 1. CLOSE ALL also closes any files opened with the FCREATE( ) and FOPEN( ) low-level file functions. CLOSE ALL does not close a file opened with SET PRINT.
CLOSE ALL also closes the following:
CLOSE ALL does not close these:
CLOSE ALTERNATE
Closes an alternate file opened with SET ALTERNATE.
CLOSE DATABASES [ALL]
Closes the current database and its tables. If there is no current database, all open free tables, indexes, and format files in all work areas are closed and work area 1 is selected.
ALL
Specifies that the following are closed:
Work area 1 is selected.
CLOSE DEBUGGER
Closes the Visual FoxPro debugger.
CLOSE FORMAT
Closes a format file in the current work area opened with SET FORMAT.
CLOSE INDEXES
Closes all open index files (both single-entry .idx and independent compound .cdx files) in the current work area. A structural compound index (a .cdx file automatically opened with the table) is not closed.
CLOSE PROCEDURE
Closes a procedure file opened with SET PROCEDURE.
CLOSE TABLES [ALL]
Closes all tables in the currently selected database. CLOSE TABLES closes all free tables in all work areas if a database isn't open.
Include ALL to close all tables in all databases, and all free tables. All databases remain open.
CLOSE TABLES should not be issued when a transaction is in progress; Visual FoxPro will generate an error message.