>>Are you absolutely, 110% sure that you really use the NOFILTER clause?
>
>Yes. Here is my exact code:
> SELECT;
> iEmp,;
> MAX(UPPER(cNameLast + cNameFrst + cNameMI));
> AS cNameSort,;
> MAX(cNameLast) AS cNameLast,;
> MAX(cNameFrst) AS cNameFrst,;
> MAX(cNameMI) AS cNameMI,;
> SUM(yDeduct) AS yDeduct,;
> MAX("1") AS cAggType;
> FROM CuDed1EmpGLA;
> GROUP BY 1;
> INTO CURSOR CuDed1Emp NOFILTER READWRITE
>
>Best regards, Chaim
I am cluesless. I do the same all the time, but I always start with a blank cursor. What happens if you do the same?
Create cursor myCursor1 .........
Select ... into cursor temp1 readwrite
Select myCursor1
Append from dbf('temp1')
Select ... into cursor temp1 readwrite
Select myCursor1
Append from dbf('temp1')