No one suggested this but ... you can also put your constant as input!
0.00835 then becomes D, etc... with just that change you saved 12 chars!
;-)
--
E
On 13:03 Tue 28 Sep , Andrew Wagner wrote:
Hey everyone,
I need to evaluate a somewhat complicated conditional statement in a calc record. Presently I need to evaluate:
field(CALC, "(235>B&& 5>D&& 5>E) ? (B*0.00835 - 0.7> A + (C-B)*0.25 ? B*0.00835 - 0.7: A + (C-B)*0.25): 0")
where the letters are input variables. When I load the record I get the error
Can't set "VOLT:PID.CALC" to "(235>B&& 5>D&& 5>E) ? (B*0.00835 - 0.7> A + (C-B)*0.25 ? B*0.00835 - 0.7: A + (C-B)*0.25): 0"
Error at or before ")" in file "MagnetCtrlApp/Db/MagnetCtrl.db" line 113
Does CALC not support nested evaluations? Perhaps I need a subroutine record? Any advice would be greatly appreciated.
Cheers,
Andrew