Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create index tag of a readonly cursor
Message
From
08/10/2007 09:54:08
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01259376
Message ID:
01259407
Views:
21
>>>>
>>>>I believe you can add one (and only one) index tag to a non-READWRITE select cursor. Vfp cleans the cdx when the cursor closes
>>>
>>>Gregory,
>>>
>>>Maybe I am missing something but I tried to add an index tag to a readonly cursor and get an error that cursor is ready only. Here is an example of how I did it:
>>>
>>>
>>>select * from mytable into cursor cur_mytable
>>>select cur_mytable
>>>index on myfield tag mytag
>>>*-- ERROR: cursor is readonly.
>>>
>>>
>>>You see anything I could be doing differently?
>>>
>>>Thank you.
>>
>>Now, that is strange
>>
>>select * from personnel into cursor pp
>>index on emp_id tag pp && ok
>>index on emp_id tag hh  && error: file ......tmp is readonly
>>
>>
>>I actually see the cdx in my tmp directory until the cursor closes
>>
>>Maybe add: NOFILTER ??
>
>You are right. NOFILTER makes a difference. Now I can create an index tag. Thank you very much.

You're welcome. I did not have the problem as I set sys(3050) to a low value at the beginning of my startup
=sys(3050,1, 64 * 1024 * 1024)
=sys(3050,2, 16 * 1024 * 1024)
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform