Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting FROM/INTO same cursor
Message
From
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:
01336428
Views:
12
>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
>
>>We have a module which creates a cursor and then returns its name. I need to further refine the selection but I'm getting an error that I'm hoping somebody here can explain.
>>myCursor = thisform.get_some_date(params)
>>this code works
>>SELECT * from (myCursor) WHERE id IN ;
>>  (SELECT id FROM (myCursor) WHERE condition);
>>  INTO CURSOR DifferentName
>>
>>but this code
>>SELECT * from (myCursor) WHERE id IN ;
>>  (SELECT id FROM (myCursor) WHERE condition);
>>  INTO CURSOR (myCursor)
>>
>>generates the Open Table dialog and then an error because it can't find the cursor (myCursor).
>>
>>It also works if I code it as
>>SELECT id FROM (myCursor) WHERE condition INTO CURSOR curHold
>>SELECT * FROM (myCursor) src;
>>                  JOIN curHold ch ON ch.id = src.id;
>>  INTO CURSOR (myCursor)
>>
>>I'm curious as to what causes MyCursor to close when using it for the FROM, IN( ), and INTO CURSOR.
>>
>>Any thoughts appreciated.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform