[Title]
Title = Sum of cutting groupped by date
[Params]
Start date  = 199901
End date    = 200013
Date pos    = 1 for 6
[Program]
0=DEBUG 1
1=SQL select substring(dtime from [Date pos]) dtime,cut,material,color from rsheet where (dtime>="[Start date]") and (dtime<="[End date]")
2=SAVE c:\temp\sub
3=SQL select dtime,sum(cut)/1000/1000 as scut from "c:\temp\sub.db" group by dtime
;3=SQL select material,color,cast(sum(cut)/1000 as integer) as scut from sub group by material,color
4=FORMAT scut,0.000
;5=FORMAT dtime,0.000
;5=SAVEAS tmp.txt
;6=COPY
;6=SAVE sub
;7=INDEX sub,dtime
;8=FORMAT scut,0.000