LCDS execute SQL statement data model

[belle_3nidad]

Hi there! I'm a newbie in lcds ES2 and flash builder 4.

Im working on a project wherein I want to bind the database to the chart.

Like if i add new status the data in the chart will also change.

Heres the pic of my project.

Hope anyone out there will be able to help me.

Thanks so much!

[Former Community Member]

Not sure I understand your question.

If you are using data management and your chart is already bound to a managed object, your chart should already be updating the data as it changes. However for your client to receive updates in real-time, all changes to the database has to go through LCDS.

Anil

[belle_3nidad]

hi there!!

i was able to solve the problem already..

i just created a view via sql..

and then bind the "getall" to the chart...

now my problem is when i add a new data the chart should also automatically update..i mean..it only updates when i refresh the browser..

[tomj]

The chart would have to listen for the collection change events and update itself when that happens.

I am not familiar with the charting APIs, so I can't help you there.

Tom