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


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