Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UNION with Order By
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00805248
Message ID:
00805259
Views:
20
This message has been marked as the solution to the initial question of the thread.
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.
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform