我用了语句创建了临时表的数据窗口,如:
ls_sql = "select * from tablename"
presentation_str="style(type=grid)"
dwsyntax_str=sqlca_source.SyntaxfromSQL(ls_sql,presentation_str,ERRORS)
if len(ERRORS)>0 then
messagebox("创建失败*","原因是: "+ERRORS)
sqlca_source.AutoCommit = False
return
end if
dw_2.Create(dwsyntax_str,ERRORS)
dw_2.settransobject(sqlca_source)
dw_2.Retrieve()
dw_2.importfile(文本文件)
但为什么dw_2.update()的时候提示错误:datawindow does not have UPDATE capability
我用了语句创建了临时表的数据窗口,如:
presentation_str="style(type=grid)"
dwsyntax_str=sqlca_source.SyntaxfromSQL(ls_sql,presentation_str,ERRORS)
if len(ERRORS)>0 then
messagebox("创建失败*","原因是: "+ERRORS)
sqlca_source.AutoCommit = False
return
end if
dw_2.Create(dwsyntax_str,ERRORS)
但为什么dw_2.update()的时候提示错误:datawindow does not have UPDATE capability