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