The SQL below crashes on the 'GROUP BY' line but still runs through to a BROWSE statement below the SQL.
Duplicates are not removed in the result. When I close the BROWSE window, the GROUP BY line is highlighted.
* Remove dupicates
USE (m.TableToSave)
SELECT * FROM (m.TableToSave)
GROUP BY hits
INTO TABLE sqltemp
SET SAFETY OFF
CLOSE TABLES ALL
COPY FILE sqltemp.DBF TO (m.TableToSave)
CLOSE TABLES ALL
What have I missed?
I ain't skeert of nuttin eh?
Yikes! What was that?