Microsoft KB Archive/299934

= FIX: Database And Table Opened with NOUPDATE Still Allows Index To Be Created =

Article ID: 299934

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q299934



SYMPTOMS
If you open a database and its tables with the NOUPDATE clause, you can still create indexes.



STATUS
This problem was corrected in Visual FoxPro version 7.0 for Windows.



Steps to Reproduce Behavior
  In Visual FoxPro (VFP) 5.0 or 6.0, paste the following code in a new program: *!* Q299934 FIX: Database and Table Opened Noupdate Still Allows Index To Be Created CREATE DATABASE Test CREATE TABLE Test (F1 C(10)) CLOSE ALL CLEAR ALL OPEN DATABASE Test NOUPDATE USE Test!Test NOUPDATE INDEX ON F1 TAG F1                    Save and run the code (the name is unimportant). The following error message appears:

Cannot update the cursor.

 Click Ignore. Type DISPLAY STRUCTURE in the Command window. The structure appears on the screen. You see that an index was created on the F1 field.

Keywords: kbbug kbfix kbcodesnippet kbvfp700fix KB299934

-

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

© Microsoft Corporation. All rights reserved.