How to show the date on the trend that queried from MS SQL SEVER in value/time form.

[BenjaminSeeker]

Now I have a function which our customer asked.
There are some data store in MS SQL Server, And I have already query those data by CtrlADO.
But How could I show those data in trend as a curve in value/time form?

[leoknipp]

Hello,

with the attribute "curveValues" for the trend you can set values with their time.
The attributes "timeBegin" and "timeInterval" are used to set the visible time range in the trend.
For details please have a look at the online help: CONTROL --> Control graphics --> Trend functions.

Best Regards
Leopold Knipp
Senior Support Specialist

[vogler]

if you have an rdb-manager and an oracle database then there would be a anohter "tricky" way ... to use all the standard trend functions, event-screen(history), ... create a "fake" archive-group, link the ms sql server database table to oracle (oracle hs gateway, odbc), create/replace a view in the rdb-manager schema to access the linked ms-sql-table ....

[vogler]

once a time i implemented a prototyp ... it was also possible to archive data to a foreign database... see the attachment. https://www.winccoa.com/fileadmin/image ... 2MySQL.pdf

[BenjaminSeeker]

Thanks a lot, I will try it!