Industry Online Support
Technical Forum
Navigation
Rating 
Thanks 0
2 Entries
| 1/19/2009 5:57 AM | |
|
Posts: 7 Rating:
|
Hi, I am new to the wincc world. I need to read thecompressed data in tagcompressed table. I get the function fn_cctlg_GetValuesByID from the Internet to decompress the data form TagCompressed Table . I have xlreporter software, When I read the sensor data by xlreporter throught the OPC and when i read the same sensorfor the same date and time byfn_cctlg_GetValuesByID function, always I have a different numbers in reading the value. How can I knowwhich programs give me the correctnumber. 1- The fn_cctlg_GetValuesByID function use the wincc functions: exec @retval = sp_cctlg_registerval @InValueId,@BLOBLength SELECT Timebegin,Timeend,BinValues FROM TagCompressed WHERE ValueID=@InValueId AND (Timebegin <= @InTimeEnd AND Timeend >= @InTimeBegin ) exec @retval = sp_cctlg_decompress @CTimeBegin, @CTimeEnd, @BinValues, @ValueAct OUTPUT exec sp_cctlg_unregisterval @InValueIdI attached copy from the function in text file . Please, advise me Best wishes, Shaekir, Attachmentgetvaluefunction.zip (121 Downloads) |
Last edited by: CS Moderator at: 1/19/2009 2:27 PMnew subject after splitting |
|
| 1/19/2009 2:29 PM | |
Joined: 9/1/2005 Last visit: 8/24/2023 Posts: 4099 Rating:
|
closed cause question posted twice. The second thread with the subject fn_cctlg_GetValuesByID functionis published within the same conference . Best regards CS Moderator |
|
My Forum is the place to personalize your profile, |
|
Follow us on