General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I need a pizza-like chart with 12 pieces where each piece is a month
I have a financial.dbf file with over 20,000 records
I would like to get the fields financial.price, and financial.date and create a sum by months
I tried to insert all data from this dbf but it resulted in an confuse chart
(maybe GDI graph does not create the query, only receives it ready ?
So, I would like a SQL code to create a small tempCursor containing: a field tempCursor.sum from financial.price
and tempCursor.month from financial.date
Then, I will send this cursor to the GDI graph
TIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only