Microsoft KB Archive/105854

Mac Works 3.0: Clearing & Deleting Records in a Database

PSS ID Number: Q105854 Article last modified on 10-22-1998

3.0

MACINTOSH

=
========================================================= 3.00 MACINTOSH kbother

= SUMMARY =

The following information describes the differences between clearing field data and deleting records in a database.

= CLEARING FIELD DATA =

These are the two main ways to clear field data.

Method 1
Select field data by doing one of the following and then choosing Clear from the Edit menu:

  Dragging over the data with the mouse -or-   Pressing the SHIFT key while clicking each field name -or-   Choosing Select All from the Edit menu -or-   Dragging over the record selector boxes with the mouse -or-   Clicking the Select All box (located to the left of the first field name) 

Method 2
Select the field data by doing one of the following and then choosing Cut from the Edit menu:

  Dragging over the data with the mouse -or-   Pressing the SHIFT key while clicking each field name </li></ol>

This second method can sometimes be confusing if you think you are cutting records when you’re actually only clearing data. In both cases, the records still remain; the data is simply removed.

NOTE: After any of the above actions, the records are still selected (that is, highlighted). This indicates that the records still exist; only the data has been removed.

= DELETING RECORDS =

There are two main ways to delete records.

Method 1
Select field data by doing one of the following and then delete the record by choosing Cut from the Edit menu:

  Drag over the record selector boxes using the mouse -or- </li>  Choose Select all from the Edit Menu -or- </li>  Click the Select All box (located to the left of the first field name) </li></ol>

Note: After any of the above actions, the selection returns to the top left corner.

Method 2
Select and delete the record by doing one of the following:

  In Data view, scroll to the record. From the Data menu, choose Delete Record. -or- </li>  In List view, select the record (by clicking the record selector box) or any field in the record. From the Data menu, choose Delete Record. </li></ol>

= MORE INFORMATION =

If you sort a field in which data has been cleared, blank spaces may appear, either at the end (for an ascending sort) or at the beginning (for a descending sort).

Records in which the data has been cleared will appear (as blank records) in filters that use the “is blank” comparison.

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: mac blank empty delete clear mwksdb =

Version : 3.0 Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.