.net应用程序查询结果与 pl/sql 查询结果不一致
有没有高手遇到过通过.net应用程序查询结果与 pl/sql 查询结果不一致的情况？
.net中得到的结果中有重复记录，而且记录不全。我将调试中得到的sql语句在pl/sql中执行，结果是我想要的。不知道不一致的原因出在哪
我的sql语句：
select xx.*, x1.*
from (select o.bankname, o.bankid, x0.*
from (select bankname, bankid
from b_f_dh_jigou r
where r.bankid != '620000000'
and r.bankid != '620400000') o
left join (select substr(b.jigou, 0, 5) as jigou,
sum(a.REPAYMENT_AMT * (CASE
WHEN c1.DISCOUNT_RATE_OF_RMB IS NULL THEN
1
ELSE
c1.DISCOUNT_RATE_OF_RMB / 100
end)) as SUM_HKHS
from odsbdata.BF_AGT_LNE_CONTRACT_REPAY_PLAN a
inner join b_f_dh_loans b on a.contract_num =
b.contract_num
left join (select b1.CM_CURR_COD,
b1.DISCOUNT_RATE_OF_RMB
from odsbdata.BF_CM_CD_CLPM_EXCHANGE_RATE b1
where b1.discount_dt =
(SELECT to_char(MAX(CLPM_DATE),
'YYYY-MM-DD')
FROM b_f_dh_sn_xqy_fun1)) c1 on (b.CURR_CD =
c1.CM_CURR_COD)
where 1 = 1
AND a.REPAY_DATE between ('2011-06-08') and
('2011-07-08')
and LOAN_STATUS_CD in ('02', '03', '04')
group by substr(b.jigou, 0, 5)) x0 on substr(o.bankid,
0,
5) =
x0.jigou) xx
left join (select substr(b.jigou, 0, 5) as jigou1,
sum(b.BALANCE_INNER_SHEET * (CASE
WHEN c1.DISCOUNT_RATE_OF_RMB IS NULL THEN
1
ELSE
c1.DISCOUNT_RATE_OF_RMB / 100
end)) as SUM_DQHS
from b_f_dh_loans b
left join (select b1.CM_CURR_COD, b1.DISCOUNT_RATE_OF_RMB
from odsbdata.BF_CM_CD_CLPM_EXCHANGE_RATE b1
where b1.discount_dt =
(SELECT to_char(MAX(CLPM_DATE), 'YYYY-MM-DD')
FROM b_f_dh_sn_xqy_fun1)) c1 on (b.CURR_CD =
c1.CM_CURR_COD)
where 1 = 1
AND b.expiring_dt between ('2011-06-08') and ('2011-07-08')
and LOAN_STATUS_CD in ('02', '03', '04')
group by substr(b.jigou, 0, 5)) x1 on substr(xx.bankid, 0, 5) =
x1.jigou1
[解决办法]
.net中得到的结果中有重复记录
是绑定后看到有重复记录还是返回的table中就有重复记录？
[解决办法]
你取出来的数据返回的是什么东西。
绑定在什么控件上。
------解决方案--------------------
断点跟踪一下，把返回的dataset看一下。gridview是不是选择自动绑定数据了
[解决办法]
请输出在PL/SQL中运行一下，是不是你在.net中的条件与你在PL/SQL中的条件不一样啊，最好在.net中把这个语句输入来，再在pl/sql中运行一下，应该不可能出现你这种情况的，我感觉是你这两个地方的条件有些不一样造成的。
