Microsoft KB Archive/139187

= FIX: Open Dialog Box Appears After Clicking Next in Wizard Form =

Article ID: 139187

Article Last Modified on 10/20/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition

-



This article was previously published under Q139187



SYMPTOMS
As you run a form that was created by using the Form Wizard, the Open dialog box appears when you click a navigation button such as the Next button. If the table used in the form is selected, the following error appears:

File is in use.

This occurs if SET COMPATIBLE is set to DB4.



WORKAROUND
Use any of the following three workarounds:

Workaround One
This workaround sets the default Compatibility of Visual FoxPro to OFF.


 * 1) On the Tools menu, click Options.
 * 2) Click the General tab.
 * 3) Clear the dBASE Compatibility check box.

Workaround Two
This workaround sets the Compatibility OFF until Visual FoxPro is restarted. In a program or in the Command window, issue the following line of code:

SET COMPATIBLE OFF

Workaround Three
This is a permanent solution. Wizard-created forms will function correctly regardless of the setting of SET COMPATIBILITY.

 Open the txtbtns class of the Wizstyle.vcx class library file. (This library is in the Wizards directory of Visual FoxPro.)  In the Initvars procedure, change the following existing line of code: THIS.nWorkarea = SELECT

to the following new line of code: THIS.nWorkarea = SELECT(0)

 Save the class.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This has been corrected in Visual FoxPro 6.0.



MORE INFORMATION
SET COMPATIBLE DB4 changes the behavior of the Initvars procedure. With the SET COMPATIBLE OFF setting, SELECT returns the currently selected work area. However, with the SET COMPATIBLE DB4 setting, SELECT returns the next available work area.

Steps to Reproduce Behavior

 * 1) Create a new form by using the Form Wizard.
 * 2) Issue a SET COMPATIBLE DB4 command.
 * 3) Run the form.
 * 4) Click the Next button.

Additional query words: move record kbtool kbprb

Keywords: kbbug kbfix KB139187

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.