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:
00019575
Vues:
54
>>>>>>>>I want to combine the contents of two cursors into another cursor.
>>>>>>>>Is this possible? Both cursor have the same number of fields and
>>>>>>>>the same field names.
>>>>What is it you're trying to do Jeff?
>>>Let's say cursora has 10 records and cursorb has 15. I want to have a
>>>cursor that has 25 records.
>>You want to "append" is the term then...you can use my idea, or there
>>are several ways to solve this, I'm sure...
>
>One of the several ways would be:
>
>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?
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