SELECT 'Sold' as Dataset,* from sold ; UNION select 'Mailed' as Dataset,* from mailed ; ORDER BY cRow INTO CURSOR tempThis command DOES work:
SELECT 'Sold' as Dataset,* from sold ORDER BY cRow INTO CURSOR tempVFP 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.