- 论坛徽章:
- 0
|
源码如下,请各位大神帮忙分析原因
+596 EXEC SQL BEGIN DECLARE SECTION;
+597 char acDate16[ DATE_LEN + 1 ];
+598 char acDate26[ DATE_LEN + 1 ];
+599 char acTranDate6[ DATE_LEN + 1 ];
+600 double dInt6 ;
+601 short id06 = 0;
+604 char acAcctNo6[ACCT_LEN+1];
+605 char acSubAcct6[ACCT_LEN+1];
+607 EXEC SQL END DECLARE SECTION;
+623 EXEC SQL SELECT SUM(tranamt)
+624 INTO :dInt6:id06
+625 FROM dpsunitsavelist
+626 WHERE ACCTNO = :acAcctNo6
+627 AND SUBACCT = :acSubAcct6
+628 AND TRANDATE > :acDate16
+629 AND TRANDATE <= :acDate26
+630 AND cdflg='C'
+631 AND ctxncode in ('dps101','275110' );
+633
+634 if( SQLCODE && SQLCODE != SQLNOTFOUND )
+635 {
+636 SQLERR_PROC
+637 strcpy( g_acRspCode, "PUB400" );
+638 sprintf( g_acRspMsg, "游标错[%ld],[%s][%s][%s]", SQLCODE ,acDate16,acDate26,acSubAcct6 );
+639 ERRLOG
+640 goto Exit;
+641
+642 }else if ( SQLCODE == SQLNOTFOUND ){
+643
+644 dInt6 = 0.00 ;
+645 }else{
+646
+648 sprintf ( g_acTrcMsg, "LEOOOOO 结息 acct[%s],sub[%s] date[%s][%s],支出[%.2f] [%d]",
+649 acAcctNo6, acSubAcct6,acDate16,acDate26 ,dInt6,SQLCODE ); TRCLOG1;
+651 }
程序日志如下:
12-17 16:54:28:557167| 649|pmdps181 |LEOOOOO 结息 acct[10010100013],sub[10010100013] date[2014-09-21][2014-12-21],支出[0.00] [0]|
按日志信息查询数据库如下:
SELECT SUM(tranamt)
FROM dpsunitsavelist
WHERE ACCTNO = '10010100013'
AND SUBACCT = '10010100013'
AND TRANDATE > '2014-09-21'
AND TRANDATE <= '2014-12-21'
AND cdflg='C'
AND ctxncode in ('dps101','275110' );
查询结果:
1
--------------
32495.97 |
|