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


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft FoxPro for Windows 2.6a
  • Microsoft FoxPro for Macintosh 2.6a
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.
Modification Type:MajorLast Reviewed:11/17/2003
Keywords:KB129920
©2003 Microsoft Corporation. All rights reserved.