Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting FROM/INTO same cursor
Message
 
 
To
04/08/2008 18:50:33
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01336417
Message ID:
01336430
Views:
12
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
Previous
Reply
Map
View

Click here to load this message in the networking platform