其中一部分语句: select sum(case when DB_QYJJLX ='340' then Qyhs else 0 end) from T_quyudslzb where DB_SSHY='000000' and Xzqh='370000' and to_char(SSSBRQ,'yyyy-mm')= '2005-02' 连接字符串1: strConnect = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=microuser;PassWord=myoracle;Data Source=myoracle"连接字符串2: strConnect = "Provider=MSDAORA.1;User ID=microuser;Password=myoracle;Data Source=myoracle;Persist Security Info=False"连接字符串1有问题 连接字符串2没有问题 用的是Oracle9i
Oracle中是应该使用decode select sum(decode(DB_QYJJLX,'340',Qyhs,0)) from T_quyudslzb where DB_SSHY='000000' and Xzqh='370000' and to_char(SSSBRQ,'yyyy-mm')= '2005-02'
select
sum(case when DB_QYJJLX ='340' then Qyhs else 0 end)
from T_quyudslzb
where DB_SSHY='000000' and Xzqh='370000'
and to_char(SSSBRQ,'yyyy-mm')= '2005-02'
连接字符串1:
strConnect = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=microuser;PassWord=myoracle;Data Source=myoracle"连接字符串2:
strConnect = "Provider=MSDAORA.1;User ID=microuser;Password=myoracle;Data Source=myoracle;Persist Security Info=False"连接字符串1有问题
连接字符串2没有问题
用的是Oracle9i
select
sum(decode(DB_QYJJLX,'340',Qyhs,0))
from T_quyudslzb
where DB_SSHY='000000' and Xzqh='370000'
and to_char(SSSBRQ,'yyyy-mm')= '2005-02'
设置
记录集的
CursorType=adOpenKeyset
LockType=adLockOptimistic