This project is read-only.

FoxCharts - Cursor

Topics: General
Aug 17, 2008 at 6:32 PM
Edited Aug 17, 2008 at 6:38 PM

I just would like to display a pizza chart with 12 pieces, where each piece has a month name,
and the sum of the numeric field on it 

I tried the SQL code below, and got a 2 column cursor:

SELECT cMonth(Date) AS Month, SUM(Price) AS Sum ;
 FROM Financial ;
 GROUP BY Month(Date) ;

However I could not insert the code in the init method of the sample form I downloaded from  this site,
because the sample has more columns in the cursor, and my cursor results in error

Any help will be welcome