4 Replies Latest reply: Feb 27, 2012 10:15 PM by clint pauyon RSS

FMS Concatenation - Internal Error

Praneeth Putlur
Currently Being Moderated

Hello Experts,

 

Can anyone help me with this FMS? I get Internal Error when i click on the formatted search but when i run this in SQL syntax it executes successfully.

 

SELECT 'Batch'= 
CASE When $[$3.U_SES_TrnsTyp.0]='Receipt' 
Then
(RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
+$[$3.U_SES_Code.0]+$[$3.U_SES_Lseq.0]+'('+$[$3.U_SES_Crg.0]+')')
When $[$3.U_SES_TrnsTyp.0]='Production' 
RIGHT(CAST(YEAR($[$3.11.DATE]) AS CHAR(4)),2) + RIGHT('000' + CAST(DATEPART(dy,$[$3.11.DATE]) AS varchar(3)),3)
Else ''
End

 

Actions