|
Ado Calc (Hach WIMS Calculation Engine) behaves erratically when a variable references a variable in a different database in which there are no calculated variables.
Symptoms:
For example if Variable 1 in database OPSWWTUTOR is a calculated variable and it references Variable 6 in database OPSHRLAB then Variable 1's equation would be V1=V6@OPSHRLAB.
Now if you entered some data in January for V6 in OPSHRLAB and then went into a MDE (monthly data entry) form in OPSWWTUTOR that has V1 on it and brought up the month of January. Now if you click on the Calculate all variables button your data for V1 will not show up, click it a second time and then your data for V1 will show up. In some cases the first time you click on the Calculate button, your data for V1 will dissappear but then if you click it again your data for V1 will reappear.
Workaround:
If you are going to be referencing data in another database, make sure you create at least 1 variable in the 2nd database that has Calculated as its type. The equation can be simple (SKIP will do the trick).
|