SELECT SUM(VOUCHER.JJE),SUM(VOUCHER.DJE),
(SUM(VOUCHER.JJE)-SUM(VOUCHER.DJE)) as BeginBalance,
VOUCHER_HEAD.DAY, VOUCHER.KMDM
FROM VOUCHER, VOUCHER_HEAD
WHERE (VOUCHER.PZ_ID = VOUCHER_HEAD.PZ_ID)
and yearof(VOUCHER_HEAD.DAY)= (lyear-1)
'GROUP BY VOUCHER.KMDM, VOUCHER_HEAD.DAY';lyear:是程序中定义的变量,取StrTOInt(combox.text)请高手帮忙匹配一下引号问题。
(SUM(VOUCHER.JJE)-SUM(VOUCHER.DJE)) as BeginBalance,
VOUCHER_HEAD.DAY, VOUCHER.KMDM
FROM VOUCHER, VOUCHER_HEAD
WHERE (VOUCHER.PZ_ID = VOUCHER_HEAD.PZ_ID)
and yearof(VOUCHER_HEAD.DAY)= (lyear-1)
'GROUP BY VOUCHER.KMDM, VOUCHER_HEAD.DAY';lyear:是程序中定义的变量,取StrTOInt(combox.text)请高手帮忙匹配一下引号问题。
解决方案 »
- C语句如何对应Delphi语句
- 如何只遍历TREEVIEW的最外层节点
- 小弟要办一个Delphi网站,请大家取个域名!
- 关于VB不懂的代码(如何转换成DELPHI中代码),求解
- 我朋友的同事(美女)歌唱比赛,来UP一下呀,还有可能获奖哦~~~~
- 将sql数据库导出为Excel文件问题!
- 如何给程序添加连接密码!!
- 请教一个数据库处理的问题,很急的
- 急!急!!急!!!请问高手们数学中的西格码等众多的数学符号怎样输入,改怎样处理??
- delphi Ctrl+鼠标左键或者Find Declaration不能定位到源文件
- 发现有不少小的共享软件都是delphi做的,不知道做这些软件的兄弟们现在生活怎么样?
- 问一个关于指针的小问题
(SUM(VOUCHER.JJE)-SUM(VOUCHER.DJE)) as BeginBalance,
VOUCHER_HEAD.DAY, VOUCHER.KMDM
FROM VOUCHER, VOUCHER_HEAD
WHERE (VOUCHER.PZ_ID = VOUCHER_HEAD.PZ_ID)
and yearof(VOUCHER_HEAD.DAY)='+inttostr(lyear-1)+
' GROUP BY VOUCHER.KMDM, VOUCHER_HEAD.DAY';