dw_1.setsqlselect()函数使用过程中产生的问题
ids_data.DataObject = "d_cx_hzyljjxzdmbcqk_lj_mx"
ids_data.settransobject(sqlca)
ls_dwsyntax = wf_pingsql("d_cx_hzyljjxzdmbcqk_lj_mx_xcx",ii_condition,idt_start,idt_end)
ls_dwsyntax = "SELECT CC.XZDM AS XZDM,CC.XZCDM AS XZCDM,CC.FPZE AS FPZE,CC.KBJE AS KBJE,CC.SBJE AS SBJE,CC.BXCS AS BXCS,DD.CYXM AS CYXM,DD.CYXB AS CYXB,DD.CSRQ AS CSRQ,DD.HZYLHM AS HZYLHM FROM (" + ls_dwsyntax &
+ " ) CC,JC_CYXX DD " + " WHERE CC.CYHM = DD.CYHM " + " ORDER BY HZYLHM "
li_setsyntax_rtn = ids_Data.setsqlselect(ls_dwsyntax)
if li_setsyntax_rtn <> 1 then
messagebox('信息提示','设置数据窗口语法错误3,无法检索出数据')
end if
clipboard(ls_dwsyntax)
if ids_Data.retrieve() <= 0 then
messagebox('信息提示',string(sqlca.sqlcode) + sqlca.sqlerrtext)
end if
这一段代码用clipboard(ls_dwsyntax)粘贴到oracle中是可以执行成功的,但在程序中却弹出代码中的提示。什么原因?
ls_dwsyntax = "SELECT CC.XZDM AS XZDM,CC.XZCDM AS XZCDM,CC.FPZE AS FPZE,CC.KBJE AS KBJE,CC.SBJE AS SBJE,CC.BXCS AS BXCS,DD.CYXM AS CYXM,DD.CYXB AS CYXB,DD.CSRQ AS CSRQ,DD.HZYLHM AS HZYLHM FROM ("
这一行取自ids_data所关联的数据窗口对象的开头,不存在setsqlselect()函数因字段数量,类型等不一致引起的问题。