Re: CALC expression

[Ralph Lange <Ralph.Lange@bessy.de>]

 When playing database golf:
In a calcout record, you can assign intermediate results to fields 
inside CALC, and then use OCAL to continue your calculation. (So you get 
>70 characters to do your math.)
Removing "unnecessary" brackets and spaces also obfuscates things 
nicely. (And saves space.)

Hole in one!
Ralph


On 28.09.2010 16:20, Ned Arnold wrote:
> Andrew -
>
> It is not uncommon to break the expression up between multiple calc records to work around the length limitation.  You can put those floating point constants in spare inputs ... and then have a second calc that returns "(235>B&&  5>D&&  5>E)" to another input ... and I think you will fit.
>
>     Ned
>
>
>
> On Sep 28, 2010, at 3:11 PM, Mark Rivers wrote:
>
> > I suspect your CALC expression is longer than 40 characters and that is
> > the source of the error.
> >
> > Mark
> >
> >
> > -----Original Message-----
> > From: tech-talk-bounces@aps.anl.gov
> > [mailto:tech-talk-bounces@aps.anl.gov] On Behalf Of Andrew Wagner
> > Sent: Tuesday, September 28, 2010 3:04 PM
> > To: tech-talk@aps.anl.gov
> > Subject: CALC expression
> >
> > 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