Deleting Diary Data Stored in the Current Resource File

ID: Q88239

2.00 2.50 2.50a | 2.50 2.50a

MS-DOS          | WINDOWS

kbprg

The information in this article applies to:

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

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a KBCategory: kbprg KBSubcategory: FxtoolAccessory

Keywords          : FxtoolAccessory 
Version           : 2.00 2.50 2.50a | 2.50 2.50a
Platform          : MS-DOS WINDOWS

Last Reviewed: April 30, 1996