advr.hlp (Topic list)
CLOSE Statement Details
  Summary  Details  Example                Contents  Index  Back
──────────────────────────────────────────────────────────────────────────────
 CLOSE [[#]filenumber% [,[#]filenumber%]...]
 
 Usage Notes
   ■ The association of a file, device, or ISAM table with the argument
     filenumber% ends when a CLOSE statement is executed. You then can
     reopen the file, device, or table using the same or a different file
     number.
 
   ■ CLOSE with no arguments closes all open files or ISAM tables and
     commits any pending ISAM transactions.
 
   ■ A CLOSE statement for a file or device that was opened for sequential
     output writes the final buffer of output to that file or device.
 
   ■ CLOSE releases all buffer space associated with the closed file, device,
     or table.
 
   ■ The following statements also close all files and devices:
     • CLEAR       • END         • RESET
     • RUN         • SYSTEM      • CHAIN (with BC /O command-line option)
     See: BC Command-Line Options
 
   ■ Any ISAM operation that closes a table causes transactions to be
     committed. For example, if a type mismatch occurs while you are
     opening an ISAM table, the table is closed and a pending transaction
     is committed.
 
   ■ You may wish to code your programs so they first open all tables,
     then perform all transactions, then close tables. Make sure any
     operation that can close a table occurs outside a transaction.