AnsweredAssumed Answered

Clear DataLink cache with VBA code?

Question asked by MaxStrueverWipro on Feb 3, 2016
Latest reply on Nov 16, 2017 by TEL1

Hi,

I was realizing there must be a cache that PI datalink uses for AF data (for non-pi-point attributes) and had been closing and reopening Excel to get the latest values (I am testing some things and changing values  in attributes without a data reference frequently and need to see them updated).

I just found the "clear cache" button in PI DataLink > Settings, which is great!

 

just curious, is there anyway in our own custom VBA code that we can access the Clear Cache function from within PI DataLink's functions?

'
Sub customFunc()
    'Clear cache for datalink before doing work??

     'PIDatalink.ClearCache() ??

    'perform calculations on super fresh data
     dim answer as integer
End Sub

 

I'm guessing no but it would be a nice-to-have

 

thanks!

Outcomes