>CREATE CURSOR CPdata ( ; > RType C(24), ; > Dtyme C(20), ; > MilliSec N(12,4), ; > ExcelTyme N(16,8), ; > DCreading N(16,7), ; > DCunit C(2), ; > ACreading N(16,7), ; > ACunit C(2), ; > TempRead N(6,1), ; > TempUnit C(2), ; > BattPot N(4,1), ; > GPSLat N(12,8), ; > GPSLon N(12,8), ; > GPSSat N(4), ; > CPNote C(48) ) >SELECT CPdata >cCPdataFyle = [C:\TEMP\UDL1_DATA\TESTDATA.CSV] >APPEND FROM (cCPdataFyle) TYPE CSV >BROWSE TITLE cCPdataFyle >>This part of the code works just as I expect it should.
>SELECT LEFT(Dtyme,18) AS Dtyme, AVG(DCreading) AS DCreading, ; > SPACE(10) AS cDate, SPACE(8) AS cHourMin ; >FROM CPdata WHERE RType=[DC] ; > GROUP BY Dtyme, cDate, cHourMin ORDER BY dTyme ; > INTO CURSOR CPchart READWRITE >BROWSE TITLE [Data to Chart] >>Problem: No grouping occurs (see attached screenshot).