I think you must order by number, for instance:
select ...
union select ...
order by 3
Where 3 is the third field, in my example.
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
