One note: the Having is like the when if no there are a When clause CFP uses Having (thats what I know)
>Select Master.PriName as Name, Count(*) as Total ;
>From Tran, Master ;
>Into Cursor C_GraphData ;
>Where Tran.PriCode = Master.PriCode ;
>Group By Tran.PriCode ;
>Having Between(Tran.DatesOn,dDateFrom,dDateUpTo)
Try the folowing:
Select Master.PriName as Name, Tran.Pricode as Code, Count(*) as Total ;
From Master Inner Join Tran On Tran.PriCode = Master.PriCode ;
Into Cursor C_graphdata ;
Where Between(Tran.DatesOn,dDateFrom,dDateUpTo) ;
Group By Tran.PriCode ;
Order By TRan.Pricode
I hope this help
Mauricio
Be fast like the Fox
Be free like the Penguin
Se Rápido como el Zorro
Se libre como el Pingüino