strSQL := 'select ''' || V_date_begin || '''' || '''至''' || --V_date_end||
-- '''||v.Account_Name||'''||'''_帐户收到款'''||
' as c_desc,(kmdm) as c_acc,KM_NAME, ' || '''借''' ||
' as jdbz,sum(v.money_detail) as money_total from view_incomeline_km v ' ||
' where pay_date>=''' || V_date_begin || '''' ||
' and pay_date<=''' || V_date_end || '''' ||
' and v.district_no=''' || V_districtNo || '''' ||
'group by Account,kmdm,KM_NAME'; open C_Cursora for strsql;其中:V_date_begin ,V_date_end,V_districtNo , C_Cursora 为变量,想实现查询的结果如下:2008-01-01至2008-04-01交通银行_帐户收到款,20101,行政事业性收入,借,5623.50求助,谢谢!
-- '''||v.Account_Name||'''||'''_帐户收到款'''||
' as c_desc,(kmdm) as c_acc,KM_NAME, ' || '''借''' ||
' as jdbz,sum(v.money_detail) as money_total from view_incomeline_km v ' ||
' where pay_date>=''' || V_date_begin || '''' ||
' and pay_date<=''' || V_date_end || '''' ||
' and v.district_no=''' || V_districtNo || '''' ||
'group by Account,kmdm,KM_NAME'; open C_Cursora for strsql;其中:V_date_begin ,V_date_end,V_districtNo , C_Cursora 为变量,想实现查询的结果如下:2008-01-01至2008-04-01交通银行_帐户收到款,20101,行政事业性收入,借,5623.50求助,谢谢!
||' (kmdm) as c_acc,'
||' KM_NAME, '
||' ''借'' as jdbz,'
||' sum(v.money_detail) as money_total '
||' from view_incomeline_km v '
||' where pay_date>='||V_date_begin
||' and pay_date<='||V_date_end
||' and v.district_no='||V_districtNo
||' group by Account,kmdm,KM_NAME'
自己再测试看看吧,应该就是这样的吧
||' (kmdm) as c_acc,'
||' KM_NAME, '
||' ''借'' as jdbz,'
||' sum(v.money_detail) as money_total '
||' from view_incomeline_km v '
||' where pay_date>=' ||V_date_begin
||' and pay_date <=' ||V_date_end
||' and v.district_no=' ||V_districtNo
||' group by Account,kmdm,KM_NAME';open C_Cursora for strsql;
提示:“未找到预期from关键字”v.Account_Name'为字段名称,V_date_begin ,V_date_end,V_districtNo , C_Cursora 为变量,view_incomeline_km 为视图。