Rich,
Without readwrite you're not necessarily creating the real cursor. Read up the link I suggested.
Did you create the cursor with READWRITE in the first place?
In any case, if this would not help, then you need to apply a two steps workaround.
Did you also try
select MyCursor.* from myCursor inner join (select ID from myCursor WHERE ...) myTempCursor on ... readwrite ?
It's better than IN (). Inner JOIN works faster than select IN ().
But this would work in VFP9 only where you can use derived tables.
>>Make sure to add READWRITE clause to your select statement.
>
>Didn't help.
>>
>>See
Re: How to pack a cursor? Thread #
1335982 Message #
1336418 (the whole thread) and check the link suggested in this message as well as another link on that site.
>>
>I've read this thread as it appeared and, sorry, but I don't see the relevance.
>
>
>
>>
http://www.berezniker.com/content/pages/visual-foxpro/queries-and-filtered-cursors>>
If it's not broken, fix it until it is.
My Blog