I JUST figured that out. It took the 'Dataset' column (not actually a field) so I copied the help and it worked.
I can actually see the logic behind that looking at the nature of the UNION clause.
Thanks a lot for the help.
Aloha,
James
>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