账表查询报错
金蝶云社区-hhlalun
hhlalun
0人赞赏了该文章 536次浏览 未经作者许可,禁止转载编辑于2019年01月25日 15:28:09
错误信息:Sql execute exception : SELECT t.SQL_BATCH, t.KSQL_SEQ, sum(CASE WHEN t.FBalSeq = 2 AND t.fperiod = 201801 THEN ISNULL(t.FSubDebitFor, 0.0) ELSE 0.0 END) FDebitFor, sum(CASE WHEN t.FBalSeq = 2 AND t.fperiod = 201801 THEN ISNULL(t.FSubCreditFor, 0.0) ELSE 0.0 END) FCreditFor, sum(CASE t.FBalSeq WHEN 1 THEN ISNULL(t.FEndBalanceFor, 0.0) WHEN 2 THEN (ISNULL(t.FSubDebitFor, 0.0) - ISNULL(t.FSubCreditFor, 0.0)) ELSE 0.0 END) FEndBalanceFor, sum(CASE WHEN t.FBalSeq = 1 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FYearDebitFor, 0.0) WHEN t.FBalSeq = 2 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FSubDebitFor, 0.0) ELSE 0.0 END) FYearDebitFor, sum(CASE WHEN t.FBalSeq = 1 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FYearCreditFor, 0.0) WHEN t.FBalSeq = 2 AND TO_INT((t.fperiod / 100)) = 2018 THEN ISNULL(t.FSubCreditFor, 0.0) ELSE 0.0 END) FYearCreditFor FROM VTZ110LFFB1O502V2DALYIB11WA9SEYDM1EY t WHERE t.FAccountID = ?
Caused exception message is: 该游标未声明。