Skip to Content

Getting error in calculation view using Sql Script View

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.

cal.png (252.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • 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.

  • Get RSS Feed

1 Answer

  • Dec 19, 2018 at 09:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded