Hi, I have a database checkpoint that checks for a numerical range.
This seems to work fine.
However I want to be able to change the min/max properties of this checkpoint through code.
SQLstr = "Select t1.VitalValue From Case_VITALS_N As t1 Left Outer Join Case_VITALS_N As t2 On t1.VitalDT < t2.VitalDT And t1.VitalCode = t2.VitalCode Where t2.VitalCode Is Null And t1.VitalCode = 'Temp1"'
DbTable("DbTable").SetTOProperty "Source", SQLstr
CheckPoint("26.CheckECG").SetProperty "Min","20" <-- 'Min' does not work
CheckPoint("26.CheckECG").SetProperty "Max","50" <-- neither does 'Max'
Ultimately I want to be able to get these min/max and sqlstr values from a datasheet (which I can do no problem). I’m just unsure of how to actually change the property of the checkpoint.
Will I have to create a separate checkpoint for every database value I check?
I want to avoid this as I have a lot of values to check, which all have numerical ranges.