FIX: Database And Table Opened with NOUPDATE Still Allows Index To Be Created (299934)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 5.0a
  • Microsoft Visual FoxPro for Windows 6.0
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.

MORE INFORMATION

Steps to Reproduce Behavior


  1. 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
  2. Save and run the code (the name is unimportant). The following error message appears:
    Cannot update the cursor.
  3. Click Ignore.
  4. Type DISPLAY STRUCTURE in the Command window. The structure appears on the screen. You see that an index was created on the F1 field.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbCodeSnippet kbvfp700fix KB299934
©2002 Microsoft Corporation. All rights reserved.