How to Create a Customized Append Screen

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

SUMMARY

To create a customized append screen, create a quick screen with Add and Quit push buttons, as explained below.

MORE INFORMATION

To create a customized append screen:

1. Create a quick screen.

2. In the first screen, select the Use Memory Variables check box.

3. Choose OK.

4. Create a push button that says "Add" (without the quotation marks).

5. In the VALID clause of the Add push button, input the following procedure:

         APPEND BLANK           && Add a blank record to end of database.
         GATHER MEMVAR          && Transfer data into blank record.
         SCATTER MEMVAR BLANK   && Clear the memory variables.
         SHOW GETS              && Refresh fields to blanks.
         _CUROBJ=1              && Put cursor on first GET object.
   
   

6. Create a push button that says "Quit" (without the quotation marks).

7. In the VALID clause of the Quit push button, input the following procedure:

         CLEAR READ             && Terminate Screen
   
   

8. In the screen layout setup code, add the following:

         SCATTER MEMVAR BLANK
   

How the Append Screen Works

When the Add button is chosen, the input on the current screen is written to the database and the fields on the screen are cleared to allow the user to input another record to be appended. To quit appending records, the user chooses the Quit button and the screen is cleared.