Steema Central

Hello,
I've just buy Tchart last week.
I want to make a chart with data on my Access database by programm.
I have write :
Graphique.Series(0).DataSource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\access\seroba\TableauxDeBordsDT.mdb;Persist Security Info=False; SQL=select * from [@PourcentageUneAffaire] where NumAffaire = '" & Me!NumAffaire & "'"

But my graph is empty.

Could you help me ?
Thanks

Hi jps,

I'd suggest you to have a look at the tutorials at TeeChart program group. Specially "Tutorial 8 - ADO Database access". You can also have a look at TeeChart features demo examples. This demo is also available at TeeChart program group.

Hello,

I have read this tutorial but I dont want to use Microsoft OLE DB
ActiveX Data Objects 1.0 Library.
When I make my chart in design mode, it work fine. I just want to change the SQL syntax to send a WHERE clause.
thanks for your responses

Hi jps,

Have you tried using TChart1.Series(0).CheckDataSource method after populating your series?

Yes I have write this line after the datasource definition :
Graphique.Series(0).CheckDataSource
but nothing appends

Hi jps,

Could you please send us an example we can run "as-is" to reproduce the problem here? You can post your files at [url]news://www.steema.net/steema.public.attachments[/url] newsgroup.

Thanks in advance.