Trend of Database File

Discussion of application development using iX Developer, including but not limited to getting started, using the functions tab, properties, objects and installation.
Post Reply
ajitkatkar
Posts: 4
Joined: Thu Nov 08, 2012 6:23 am

Trend of Database File

Post by ajitkatkar »

Is it possible to make a trend of the data stored in SQL file? I have a Database file in .sdf format and a table of numneric values. I want to create a trend of this table. Is it Possible? The Format of data in table is as follows :

Time T1 T2 T3 T4 T5 Pr.
10:10:10 30.4 25.4 30.6 34.7 32.3 -0.034
10:11:10 40.3 37.5 35.8 38.9 39.2 -0.455
10:12:10 50.3 51.3 52.6 51.8 54.2 00.345
...
...
...

Thanks
Ajit Katkar

mark.monroe
Posts: 824
Joined: Tue Mar 13, 2012 9:53 am

Re: Trend of Database File

Post by mark.monroe »

If you are using the datalogger in iX Developer, you can have the trend viewer point to the datalogger and it will show the data.

If you are handling this data outside the datalogger framework, then you would have to use a chart object and populate it with your data. Chart objects use arrays and display the data in them. You would populate your array via a database query and then it would display your data.
Best Regards,
Mark Monroe

Beijer Electronics, Inc. | Applications Engineer

Post Reply