Microsoft KB Archive/88239

{| = Deleting Diary Data Stored in the Current Resource File =
 * width="100%"|

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 &quot;DIARYDATA&quot; 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.