Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UNION with Order By
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00805248
Message ID:
00805267
Vues:
26
Excellent, thanks Jaime.

>Caroline
>Try
>lnFields = allt(str(fcount("DirectAddress")))
>
>Select DirectAddress.*, .T. as Direct, nSSC as Code;
>from DirectAddress;
>union select ResidueAddress.*, .F., Residue;
>from ResidueAddress;
>order by &lnFields desc;
>into Cursor AddressOrder nofilter
>
>HTH
>Jaime
>
>>I'm doing a Union with 2 identical tables and I'm trying to order be some additional fields that I'm adding. However if I put a variable as the field number to order by I get an error.
>>Could someone please help.
>>
>>lnFields = fcount("DirectAddress")
>>
>>Select DirectAddress.*, .T. as Direct, nSSC as Code;
>>from DirectAddress;
>>union select ResidueAddress.*, .F., Residue;
>>from ResidueAddress;
>>order by Evaluate(lnFields) desc;
>>into Cursor AddressOrder nofilter
>>
>>Thanks in anticipation.
Caroline
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform