Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting FROM/INTO same cursor
Message
 
 
À
04/08/2008 21:14:15
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:
01336570
Vues:
11
I'm not sure why you''re using a subquery. Your query is equivalent to
SELECT * FROM (lcReturn) ;
                   WHERE activity = "Passed - waiting for source" ;
                    AND EMPTY(date_end) ;
  INTO CURSOR (lcReturn)
>
>lcReturn = thisform.odata.Get_RMA_Status_By_Customer(ldteStart, lDteEnd, lcCustomer, lcStatus)
>
>SELECT * FROM (lcReturn) ;
> WHERE rma_no IN (SELECT rma_no FROM (lcReturn);
>                   WHERE activity = "Passed - waiting for source" ;
>                    AND EMPTY(date_end)) ;
>  INTO CURSOR (lcReturn)
>
>etc
>
>It seems to be the combination of the same cursor for the FROM, IN, and INTO portions of the query. Several variants worked quite well.
>
>I also tried putting the actual cursor name, rather than the variable reference, into the query and got the same error.
>
>FWIW, I get the same error using VFP 9
>
>I have alternatives which are working so this is not a big issue for me. I was, and still am, curious as to what might be happening within VFP to cause this problem.
>
>Thanks for any insight
>
>.........Rich
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform