如下程序:查询语句中包含中文,datawindow报错!
tmpdate=ta.search.dw_search.getitemdate(ins,"birthday")
if not isnull(tmpstr) then
str=str+" and "+"birthday='"+string(tmpdate,"yyyy-mm-dd")+"'"
end if
tmpdate=ta.search.dw_search.getitemdate(ins,"build_date")
if not isnull(tmpstr) then
str=str+" and "+"build_date='"+string(tmpdate,"yyyy-mm-dd")+"'"
end if
str="select * from pati_base_info where "+str
dw_amendmz.setsqlselect(str)
dw_amendmz.retrieve()