PRB: Browse Window Called 'Locate Record' Won't Allow Changes

ID: Q131869

The information in this article applies to:

Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a

SYMPTOMS

You see the title 'Locate Record' on the Browse window, and you are not allowed to make any changes to the records in the window.

CAUSE

This is due to a code change in Foxapp.app. In versions prior to 2.6, Foxapp allowed you to choose Browse from the Application menu. However, this was changed in version 2.6; Browse became Locate.

After the Foxapp-generated program completes all attempts to browse a table, the Browse window with the "Locate Record" title appears. No modifications or deletions are possible in this window.

This happens when you choose Browse because the Browse choice uses the BROWSE LAST command. BROWSE LAST uses the structure of the last Browse issued, which in this case, was generated by Foxapp.

RESOLUTION

Use either of the following two solutions:

Enter BROWSE in the Command window. All menu options will now work correctly. This solution is temporary, each time the Foxapp-generated application is run, it will reset the BROWSE.
-or-

Modify the Appmenu.mpr program generated by Foxapp. If you choose to do this, note that it permanently changes the application's read-only BROWSE to one that can be modified. To do this, follow these steps:

1. Open the project Customer.pjx.

2. Edit the Appmenu menu. Then edit the application submenu. Scroll the

      list to find the 'Locate' prompt. Edit the procedure associated with
      this prompt. You will see a command statement that reads:

         BROWSE WINDOW FA_loc NOEDIT NODELETE NOAPPEND ;
         NOMENU TITLE "Locate Record" COLOR SCHEME 10

      Change it to read:

         BROWSE WINDOW FA_loc  ;
         NOMENU TITLE "Locate Record" COLOR SCHEME 10

      By removing NOEDIT NODELETE NOAPPEND, you make the Browse modifiable.
      See the Language Reference (pp. L3-232 - L3-251) for a description of
      the other clauses.

      Press CTRL+W twice to save the changes to the procedure and Appmenu.

   3. Build the Application,and test the results of your changes by
      starting from step 2 in the "Steps to Reproduce Behavior" section
      of this article.

NOTE: You can choose to change the name of the menu bar option from Locate to Browse.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create an application using Foxapp and the Customer.dbf table. Run the

   application.

2. On the Application menu, click Locate. The Browse window appears. Press

   the ESC key to close the Browse. Close the screen by clicking the Quit
   button.

3. Open the Customer table. On the Database menu, click Browse.

Additional reference words: FoxWin 2.50 2.50a 2.50b 2.60 2.60a KBCategory: kbprg kbtool kbprb KBSubcategory: FxprgBrowse

Last Reviewed: July 5, 1995