Navigation
Rating 
Thanks 0
2 Entries
| 1/19/2009 7:28 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 correctnumbers or I miss something. 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, Prog_Ana Attachmentgetvaluefunction.zip (395 Downloads) |
Follow us on