I am using TDA v2.6 and in my automation script I am trying to setup three variables (aw, ss, wk) and I am able to get one working (wk) but the other two are failing and I get the below error (extract from log file):
– 16/06/2010 12:56:32: AR_Seasonal.log: Variable “aw” set to “#WK_SEAS.AW_SEAS#”
– 16/06/2010 12:56:32: AR_Seasonal.log: Variable value = Syntax error
I have narrowed the issue down the fact that the variable can not handle the / in the value it is getting from the result set. An example in this case is 2010A/W, when the result was 2010AW the variable could handle it.
Is there anyway around this as 90% of our season codes (that’s what the value above is!) have these in?