Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting FROM/INTO same cursor
Message
De
04/08/2008 18:50:33
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01336417
Message ID:
01336428
Vues:
13
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform