Sorry, my fault: with UNION the order statement needs the column number, not name:
... order by 1
>That seems to work -- if I don't use the order by clause. I get an error squawk if I do use it.
>
>
>
>>
I have a combobox in a grid with RowSourceType = 3, and the following RowSource:
>>select partno, descript from PartsList where empty(Prodalias) into cursor TempCombo order by partno
>>Is there some way to insert a blank row into the beginning of this cursor as part of this statement?>>
>>
>>SELECT [ -- None -- ] AS partno, [ -- Not Applicable -- ] AS descript FROM PartsList UNION SELECT partno, descript from PartsList where empty(Prodalias) into cursor TempCombo order by partno
>>
>>
>>You just need to be sure that you use PADR() to make sure that the fields are the same length in both parts of the UNION.