How to Recycle Deleted Records in a Multiuser Environment (95250)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft FoxPro for MS-DOS 2.0
  • Microsoft FoxPro for MS-DOS 2.5
  • Microsoft FoxPro for MS-DOS 2.5a
  • Microsoft FoxBASE+ for MS-DOS 2.1
  • Microsoft FoxPro for Windows 2.5
  • Microsoft FoxPro for Windows 2.5a
  • Microsoft FoxBASE+ for Macintosh 2.1
  • Microsoft FoxPro for Macintosh 2.5b
This article was previously published under Q95250

SUMMARY

The DELETE command does not physically remove a record from the database file. Instead, it places a flag on the record indicating that the record has been deleted. The record can be retrieved by issuing the RECALL command.

The PACK command physically removes deleted records from the file. After the PACK command has been issued, deleted records cannot be recalled. Using PACK requires exclusive use of the file.

In a multiuser environment, it may be difficult to obtain exclusive use of the file for packing. If the file isn't packed, the amount of disk space required to store deleted records will continue to grow. To work around this problem, you can recycle deleted records by using the technique illustrated below.

MORE INFORMATION

The following code snippets blank out all fields in the record when a record is deleted from the file. When an attempt is made to append a new record to the database, the program first checks to see if any blank deleted records are available. If a deleted record is available, the program uses the record to store the new data. If a deleted record is not available, the program appends a blank record.

This code snippet deletes a record in FoxBASE+: 
   DELETE
   *   Insert code here to replace each field with a blank character,
   *   date or numeric value.
This code snippet deletes a record in FoxPro: 
   IF LOCK()
      SCATTER MEMVAR MEMO BLANK   *  See note below on memo fields.
      GATHER MEMVAR MEMO          *  MEMO keyword available only
      DELETE                      *  in FoxPro 2.0.
   ENDIF
The following line must be added to a FoxBASE+ or FoxPro 1.02 program for databases that contain memo fields: 
   REPLACE memofield WITH ""  && memofield is the memo field name
This code snippet either recycles a deleted record or appends a new blank record in FoxBASE+ and FoxPro: 
   LOCATE FOR DELETED()
   IF EOF()
      APPEND BLANK
   ELSE
      RECALL
   ENDIF
Unused space in memo files will not be recycled. To recover unused space in memo files, you must issue a PACK (FoxBASE+) or PACK MEMO (FoxPro) command.

REFERENCES

Microsoft FoxPro "Commands & Functions," pages 134, 315, and 580
Modification Type:MajorLast Reviewed:12/3/2003
Keywords:KB95250
©2003 Microsoft Corporation. All rights reserved.