Trending Chart

[Phrog30]

OK, is this not what you were looking for?
https://www.infoq.com/news/2009/08/SQLite-Has-Been-Ported-to-.NET

[Archie]

OK, is this not what you were looking for?
https://www.infoq.com/news/2009/08/SQLite-Has-Been-Ported-to-.NET

That would be an ideal solution. It looks like it has been abandoned. Might be a good project to pick up on.

I did find another .NET SQL database project that seemed to be active and very promising, but I was not able to get it to work. When I emailed the support page it went to a bad link, so I took it as a bad sign and gave up on it. I don't even remember what the name of that project was.

[Phrog30]

It looks like it's being actively developed, https://www.nuget.org/packages/sqlite-net/, there is a beta as a month ago.  If the 2014 version is stable, it's probably worth looking into.

[Archie]

It looks like it's being actively developed, https://www.nuget.org/packages/sqlite-net/, there is a beta as a month ago.  If the 2014 version is stable, it's probably worth looking into.

That one looks like a different project because on GitHub it says it is a wrapper around SQLite.

https://github.com/praeclarum/sqlite-net

The C#-SQLite is a full implementation. The last activity I saw for it was 2014

[Archie]

This one looks like the full .NET version of SQLite :

https://www.nuget.org/packages/Csharp-Sqlite/

[Phrog30]

It looks like it's being actively developed, https://www.nuget.org/packages/sqlite-net/, there is a beta as a month ago.  If the 2014 version is stable, it's probably worth looking into.

That one looks like a different project because on GitHub it says it is a wrapper around SQLite.

https://github.com/praeclarum/sqlite-net

The C#-SQLite is a full implementation. The last activity I saw for it was 2014

I guess I didn't look close enough.

[DavidSr]

Archie would it be impractical to implement an option to schedule a start and stop time for the chart?
  - After thinking on this a bit, If it is not too difficult to start and stop the chart by using a plc bit to trigger it, then that would accomplish three scenarios.

1.) Stopping an starting from the HMI
2.) Starting / stopping the chart by an event in the PLC
3.) Scheduling the Chart by triggering a bit in the PLC  based on the PLC clock.

I don't know what the difficulty would be to implement that. What do you think?

[Archie]

Archie would it be impractical to implement an option to schedule a start and stop time for the chart?
  - After thinking on this a bit, If it is not too difficult to start and stop the chart by using a plc bit to trigger it, then that would accomplish three scenarios.

1.) Stopping an starting from the HMI
2.) Starting / stopping the chart by an event in the PLC
3.) Scheduling the Chart by triggering a bit in the PLC  based on the PLC clock.

I don't know what the difficulty would be to implement that. What do you think?

The latest version has a PLCAddressEnableLogging property that lets you start/stop with a PLC bit. Or you could use the EnableLogging property and control it via VB code.

[Gene T.]

I keep having a problem with the chart stopping. I get this error when I try to navigate to the chart. I can select continue and when the chart opens it is not showing real time data even though I checked the log and I see entries in the CSV file.
The error is attached.

Also wanted to say that this error only occurs while running the application by starting with the advancedHMI.exe. If I run inside of visual studio starting the application in debug the chart will stop but I don't get any error that I am aware of.

Gene

[Archie]

I keep having a problem with the chart stopping. I get this error when I try to navigate to the chart. I can select continue and when the chart opens it is not showing real time data even though I checked the log and I see entries in the CSV file.
The error is attached.

Also wanted to say that this error only occurs while running the application by starting with the advancedHMI.exe. If I run inside of visual studio starting the application in debug the chart will stop but I don't get any error that I am aware of.

Gene

Can you expand down the details and see what vb file and line number the error occurs?

[Gene T.]

I copied the text into a .txt file below. Also wanted to let you know if I click continue on the error screen the chart will open and eventually will start working again but if I leave and return the error pops up again.

Gene

[prof-nova]

Hi, this charting component works fine for me.
However, how can I fix the y scale to a defined value.
Thanks.

[Archie]

Hi, this charting component works fine for me.
However, how can I fix the y scale to a defined value.

The current version only does auto scaling of the Y Axis. I'll see about adding a fixed scale to a future version.

[prof-nova]

Hi, this charting component works fine for me.
However, how can I fix the y scale to a defined value.

The current version only does auto scaling of the Y Axis. I'll see about adding a fixed scale to a future version.

OK thanks anyway

[Archie]

Hi, this charting component works fine for me.
However, how can I fix the y scale to a defined value.

Beta 29 now has YAxisMaximum and YAxisMinimum properties.