when you use the "union" clause the "order by" can not be a field name, but must be a field number

hope this helps.



>Hi All,
>
>I can't figure this one out...
>
>This command doesn't work:
>

>SELECT 'Sold' as Dataset,* from sold ;
>       UNION select 'Mailed' as Dataset,* from mailed ;
>       ORDER BY cRow INTO CURSOR temp
>

>
>This command DOES work:
>

>SELECT 'Sold' as Dataset,* from sold ORDER BY cRow INTO CURSOR temp
>

>
>VFP 8 is telling me that the error is in my Order clause. The data in cRow is a number range (i.e. ' 700 - 799') right justified to 25 characters. The desired result is to combine the two cursors (output from the XTab FFC) and order by cRow (number range) and Dataset. If I don't use cRow and just use Dataset the query executes fine, its just the cRow for some reason.
>
>Thanks in advance for any help.
>
>Aloha,
>
>James