Microsoft KB Archive/129920

From BetaArchive Wiki
Knowledge Base


PRB: INDEX ON produces 'File is read-only' Error with Cursor

Article ID: 129920

Article Last Modified on 11/17/2003



APPLIES TO

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft FoxPro 2.6a Standard Edition
  • Microsoft FoxPro 2.6a Professional Edition for Macintosh



This article was previously published under Q129920

SYMPTOMS

When attempting to create an INDEX for a read-only cursor, you receive this error:

File is read-only

RESOLUTION

Specify an .IDX file for the tags to be added to. For example, issue the following commands to create the two tags without yielding the error message:

   USE tutorial\customer
   SELECT * FROM customer WHERE state = 'CA' INTO CURSOR test
   INDEX ON zip+city TAG zip_city OF tutorial\testzip.idx
                

Because you can have only one IDX file assoicated with a cursor open at a time, you need to recreate the new index as needed with these commands:

   SET ORDER TO
   INDEX ON cno+company TO c:\fpw26\test2.idx
                

STATUS

This behavior is by design.


Additional query words: FoxWin FoxMac

Keywords: KB129920