cancel
Showing results for 
Search instead for 
Did you mean: 

Getting error in calculation view using Sql Script View

impradeepy
Active Participant
0 Kudos

Dear Team,

Schema name is A_GM

SELECT 'IC Pymt' "DocType", T0."CardCode", T0."DocDate", T0."DocTotalSy",T0."CheckAcct", T0."BPLName", T0."CashAcct", T0."Canceled", T1."CardName", T1."City", T1."CardType", T1."State1",T2."GroupName", T3."AcctName" FROM "A_GM"."OVPM" T0 LEFT OUTER JOIN "A_GM"."OCRD" T1 ON T0."CardCode" = T1."CardCode" LEFT OUTER JOIN "A_GM"."OCRG" T2 ON T1."GroupCode" = T2."GroupCode" LEFT OUTER JOIN "A_GM"."OACT" T3 ON T0."CardCode" = T3."AcctCode" UNION ALL SELECT 'IC Pymt' "DocType", T0."CardCode", T0."DocDate", T0."DocTotalSy",T0."CheckAcct", T0."CashAcct", T0."Canceled", T0."BPLName", T1."CardName", T1."City", T1."CardType", T1."State1",T2."GroupName", T3."AcctName" FROM "A_GM"."ORCT" T0 LEFT OUTER JOIN "A_GM"."OCRD" T1 ON T0."CardCode" = T1."CardCode" LEFT OUTER JOIN "A_GM"."OCRG" T2 ON T1."GroupCode" = T2."GroupCode" LEFT OUTER JOIN "A_GM"."OACT" T3 ON T0."CardCode" = T3."AcctCode"

Please find the screenshot for the error.

pfefferf
Active Contributor

Can you please show the whole code. You said that this is part of a scripted calculation view, I miss the part which sets the result parameter. Probably just a missing ";" is the issue.

Accepted Solutions (0)

Answers (1)

Answers (1)

impradeepy
Active Participant
0 Kudos

Hello Florian,

Thanks for the reply,I just rechecked the query i forgot to put semicolon at the end of the query.

Now error is gone thank you.

Best Regards