>>Hi,
>>
>>I need to change a hard-coded expression into a variable (stored in the app object). The expression has a variable - name of the alias - which may change in different parts of the app. Here is an example (close to actual case):
>>
>>Right now, hard coded:
>>
>>nQty = EVALUATE(tcAliasName + ".INSTOCK") + EVALUATE(tcAliasName + ".ONORDER") - EVALUATE(tcAliasName
>>+ ".REORDERPNT")
>>
>>
>>If I place the entire hard-coded expression to a variable, as:
>>
>>cExpr = 'EVALUATE(tcAliasName + ".INSTOCK") + EVALUATE(tcAliasName + ".ONORDER") - EVALUATE(tcAliasName + ".REORDERPNT")'
>>
>>
>>Will the above work as?
>>
>>nQty = EVALUATE( cExpr )
>>*-- or
>>nQty = &cExpr.
>>
>>
>>TIA
>
>
>TEXT TO cExpr NOSHOW TEXTMERGE PRETEXT 15
> <<tcAliasName>>.INSTOCK +
> <<tcAliasName>>.ONORDER -
> <<tcAliasName>>.REORDERPNT
>ENDTEXT
>
>nQty = EVALUATE( cExpr )
>
First, thank you. Your approach should work and should be my solution. But I have changed the TEXT TO ENDTEXT to a string (because I will store it in the app object). So in my case I have
cExpr = "<<tcAliasName>>.INSTOCK + <<tcAliasName>>.ONORDER - <<tcAliasName>>.REORDERPNT"
nQty = EVALUATE( cExpr )
But I get error Missing Operand. I must be doing something wrong. I will keep checking my syntax.
UPDATE. The error is actually Missing Expression, not Operand.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
