oracle817 group by 简单问题
cslf 2006-08-02 10:26:08 服务端:os是hp,db是ora817
存在问题;
用odbc操作没问题。
用Provider=MSDAORA.1;Password=pwd;User ID=user;Data Source=yz;Persist Security Info=True
时rsopen时报不是分组函数。
sql:select a.billingmonth billingmonth,a.accountid accountid,sum(a.allfee) allfee,sum(s.balance) balance from bill a,account s where a.billingmonth=(select to_char(sysdate,'yyyymm') from dual) and a.accountid='8910000032909' and s.accountid=a.accountid and a.SUBSCRIBERID='8910000019122' group by a.billingmonth,a.accountid
conn是客户端游标。