Naomi:
Here is the View definition,
SELECT TOP 10 Calllog_vfp.calltype, COUNT(0) AS totalbytype,;
"0000-00-00" AS startdate, "0000-00-00" AS enddate;
FROM ;
heat_support!calllog_vfp;
WHERE Calllog_vfp.closeddate >= ( ?MDate21 );
AND Calllog_vfp.closeddate <= ( ?MDate22 );
GROUP BY Calllog_vfp.calltype;
ORDER BY 2 DESC
DBSetProp(ThisView,"View","SendUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","WhereType",3)
DBSetProp(ThisView+".calltype","Field","DataType","C(15)")
DBSetProp(ThisView+".calltype","Field","UpdateName","heat_support!calllog_vfp.calltype")
DBSetProp(ThisView+".calltype","Field","KeyField",.F.)
DBSetProp(ThisView+".calltype","Field","Updatable",.F.)
DBSetProp(ThisView+".totalbytype","Field","DataType","N(10)")
DBSetProp(ThisView+".totalbytype","Field","KeyField",.F.)
DBSetProp(ThisView+".totalbytype","Field","Updatable",.F.)
DBSetProp(ThisView+".startdate","Field","DataType","C(10)")
DBSetProp(ThisView+".startdate","Field","UpdateName",CHR(34)+"0000-00-00"+CHR(34))
DBSetProp(ThisView+".startdate","Field","KeyField",.F.)
DBSetProp(ThisView+".startdate","Field","Updatable",.F.)
DBSetProp(ThisView+".enddate","Field","DataType","C(10)")
DBSetProp(ThisView+".enddate","Field","UpdateName",CHR(34)+"0000-00-00"+CHR(34))
DBSetProp(ThisView+".enddate","Field","KeyField",.F.)
DBSetProp(ThisView+".enddate","Field","Updatable",.F.)i will check in the century setting, the set date was already set to set date YMD.
