Microsoft KB Archive/112240

From BetaArchive Wiki

Article ID: 112240

Article Last Modified on 11/17/2003



APPLIES TO

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft FoxPro 2.6 Standard Edition
  • Microsoft FoxPro 2.6 for MS-DOS



This article was previously published under Q112240

SUMMARY

Screens created with the Screen Wizard do not alter the setting of SET EXCLUSIVE. In order to use a screen that was created with the Screen Wizard in a multiuser environment, you must issue the SET EXCLUSIVE OFF command before running the screen.

MORE INFORMATION

NOTE: A database can be opened as SHARED without issuing SET EXCLUSIVE OFF prior to opening the database.

Example 1

NOTE: This is an example of running a screen that was created with the Screen Wizard in a multiuser environment.


FoxPro 2.x Code:

   SET EXCLUSIVE ON
   USE xyz.dbf SHARED
   DO screen.spr          && This screen could be a screen that was
                           * created with the Screen Wizard.

Visual FoxPro Code:

   SET EXCLUSIVE ON
   USE xyz.dbf SHARED
   DO FORM screen.scx          && This screen could be a screen that was
                                * created with the Screen Wizard.
                

Example 2

NOTE: This is an example of running a screen that was created with the Screen Wizard in a multiuser environment.

FoxPro 2.x Code:

   SET EXCLUSIVE OFF
   USE xyz.dbf
   DO screen.spr         && This screen could be a screen that was
                          * created with the Screen Wizard.
                

Visual FoxPro Code:

   SET EXCLUSIVE OFF
   USE xyz.dbf
   DO FORM screen.scx          && This screen could be a screen that was
                                * created with the Screen Wizard.
                

For more information about multiuser programming, see page D19-6 in the FoxPro for Windows "Developer's Guide."


Additional query words: VFoxWin FoxDos FoxWin 2.6 SCR dBASE CONVERSION MIGRATE CANCEL screenwizard multi-user

Keywords: kbnetwork KB112240