Appending Records Using the Default Popup Value in FoxPro

ID: Q90030

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

To append new records to a database using the default (or initial) value defined in a screen popup, edit the APPEND procedure to replace the popup field with the default value.

When a user appends records using the control panels provided with Microsoft FoxPro, the VALID procedure performs an APPEND BLANK command. This command automatically completes all fields with blanks or zeros. Because the popup default value is used only for an empty field, the blanks override the default. To change this behavior, use the REPLACE WITH command immediately after the APPEND BLANK to replace the field in the popup with the default value.

For example, if the popup field is called state and the default value is "WA," change the APPEND procedure to read as follows:

   APPEND BLANK
   REPLACE state WITH "WA"
   SHOW GETS

Last Reviewed: June 27, 1995