Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combining two cursors
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00019482
Message ID:
00019615
Vues:
56
>>>SELECT * ;
>>> FROM cursorA ;
>>> INTO CURSOR cursorC ;
>>> ORDER BY orderField
>>>UNION ;
>>>SELECT * ;
>>> FROM cursorB
>>Hmmm...this looks good, but when I tried it I only got records from
>>cursorA. Is there something missing?
>
>Yeah, the semicolon after the ORDER BY clause. :-( Also, you could ORDER BY 1 instead, if that did what you wanted....

I guess you saw my other message where with advice from Arnon it's working fine. I figured there was an SQL way (or two) of doing the cursor append, but I often spend more time trying to get something to work correctly than if I just do a FOR loop or something off the top of my head, you know how that is :~)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform