Deleting Diary Data Stored in the Current Resource File

• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
• Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SUMMARY

You can delete a number of diary entries by starting the Calendar/Dairy program and deleting each entry individually. However, there is a more efficient way to do this, as explained below.

MORE INFORMATION

Each diary entry is stored in the current resource file as an individual resource record. Deleting the records from the resource file removes the diary entries. To list only the diary entries in a Browse window and mark the entries for deletion, do the following:

1. Issue the SET RESOURCE OFF command in the Command window to turn off the resource file.

2. Open the resource file with the USE FOXUSER or USE SYS(2005) command. The default resource file is FOXUSER.DBF.

3. Use the following command to open a Browse window that contains only the diary entries:

         BROWSE FOR ID = 'DIARYDATA'
   

   Note that "DIARYDATA" must be in uppercase letters. In each diary record, the DATA field is a memo field that contains the diary entry. The NAME field contains the calendar date (in the format YYYYMMDD) to which the entry is associated. The UPDATED field contains the system date when the entry was created.

4. Mark the records you want to delete.

5. Pack the database to eliminate the marked records.

6. Issue the SET RESOURCE TO FOXUSER command in the Command window to turn the resource file on.

REFERENCES

"Interface Guide," version 2.0, "System Menu" chapter, "Calendar/Diary" section

"User's Guide," version 2.5 (MS-DOS), "System Menu" chapter, "Calendar/Diary" section

"User's Guide," version 2.5 (Windows), "Help Menu," chapter, "Calendar/Diary" section