SELECT PADR("Activity",20," ") AS Name , 99 AS Nomer FROM Funds WHERE Kod == 1; UNION SELECT SPACE(20) AS Name, 00 AS Nomer FROM Funds WHERE Kod == 1; INTO CURSOR cAttr1But the result cursor is ordered:
* I Expect Name Nomer ------------- ------ "Activity " 99 " " 0 *** The Result ???????????????? Name Nomer ------------- ------ " " 0 "Activity " 99I have no ORDER BY clause
SELECT SPACE(20) AS Name, 00 AS Nomer FROM Funds WHERE Kod == 1; UNION SELECT PADR("Activity",20," ") AS Name , 99 AS Nomer FROM Funds WHERE Kod == 1; INTO CURSOR cAttr1TIA