>>Hi guys,
>>Can you use SELECT SQL statement on cursors? I have a cursor called tempcur and I had this satement :
>>
>>SELECT tempcur.clerk, tempcur.rates;
>> FROM tempcur;
>> GROUP BY clerk;
>> ORDER BY clerk;
>> INTO DBF output/entries
>>
>>
>>I get an error message "Invalid path or file name" when I run the form. What's wron with this? I would be glad of any help from you guys.
>
>Richard,
>To be able to do it cursor should be a true cursor. For your tempcur creating SQL add a 'nofilter' clause. ie:
>
>select * from myTable into cursor tempCur NOFILTER
>
>However if you could do this in first place do it there.
>Cetin
BTW if your order by is same as group by then you don't need order by (group by does implicit order by).
Cetin