Skip to Content
0
Former Member
Sep 26, 2011 at 09:16 AM

Script logic select statement error (*SELECT(%YEAR%,"[YEAR]","T_TIME",”[ID]

453 Views

Hi

i am trying to use the below statement . its giving error . pls have a look

*SELECT(%YEAR%,"[YEAR]","T_TIME",u201D[ID]=%T_TIME_SET%u201D)

*SELECT(%PYEAR%,"[YEAR]-1","T_TIME",u201D[ID]=%T_TIME_SET%u201D)

*RUNALLOCATION

*FACTOR=1

*DIM T_MOVEMENTS WHAT = CB; WHERE=OB;

*DIM T_TIME WHAT=MAR.%PYEAR%; WHERE=BAS(TOTAL.%YEAR%)

*ENDALLOCATION

*COMMIT

The resule

Validation status of executable file: Failed

- Incorrect syntax near 'u201D'. in:select [YEAR] from mbrT_TIME where u201D[ID]=%T_TIME_SET%u201D

Validation status of syntax: Failed

- Invalid syntax found; see statements in red

Bud if specify the year its running properly. pls advice me whare i was wrong

Thanks