Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

The functions that i need to read the binvalue in Tagcompresseed table in

Created by: Prog-Ana at: 1/28/2009 12:37 AM (1 Replies)

Rating (2)

Thanks 0

2 Entries

1/28/2009 12:37 AM	Rate (1)
Prog-Ana Posts: 7 Rating: (2)	I finished an archiving project for pcs7, the aproach we used is to copy the data directly from the SQL database rather than read through OPC. When I tried to read data from binvalues in TagCompressed table I used sp_cctlg_registerval , sp_cctg_decompress , sp_cctlg_getvalue , and sp_cctlg_unregisterval The the data I extract is not correct although sometimes close. Are there any procedure / function I missed. Best wishes, Attachment getvaluefunction.zip (533 Downloads)
Prog-Ana Posts: 7 Rating: (2)
Suggestion To thank Quote Answer

1/28/2009 8:25 PM	Rate (1)
Prog-Ana Posts: 7 Rating: (2)	The function is working well and the number is correct , and you can call the function directly by using select * from fn_cctlg_GetValuesByID(1,'10/25/2008 00:00:00','10/25/2008 00:00:00') under sql server. The problem was there is shifting 6 hr. so that is made the confilict between the function report and xlreporter report because there is a 6 hr shifting .My boss said it's GMT problem Best wishes, Prog_Ana;
Prog-Ana Posts: 7 Rating: (2)	Last edited by: Prog-Ana at: 1/28/2009 8:55 PM Last edited by: Prog-Ana at: 1/28/2009 8:45 PM
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on