报表查询时间段出现问题
string ls_begindate,ls_enddate,ls_sql
ls_begindate = em_begin.text + '00:00:00'
ls_enddate = em_end.text +'23:59:59'
ls_sql = is_oldsql + "and pat_resi_info.admission_time>="'+ls_begindate+'"and pat_rest_info.admission_time<="'ls_enddate"'"
dw_print.setsqlselect(ls_sql)
dw_print.retreve()
这个是代码,运行出现文字与格式字符串不匹配
差错发现是dw_print.setsqlselect(ls_sql)中的ls_sql的问题
SELECT "PAT_RESI_INFO"."RESI_NO",
"PAT_RESI_INFO"."PAT_NAME",
"PAT_RESI_INFO"."SEX",
"PAT_RESI_INFO"."AGE",
"PAT_RESI_INFO"."BED_NO",
"PAT_RESI_INFO"."IN_DEPT",
"PAT_RESI_INFO"."DISCHARGE_TIME",
"PAT_RESI_INFO"."ADMISSION_TIME",
"PAT_SETTLE_MASTER"."PAYMENTS",
"PAT_SETTLE_MASTER"."COST"
FROM "PAT_RESI_INFO", "PAT_SETTLE_MASTER"
WHERE ("PAT_RESI_INFO"."RESI_NO" = "PAT_SETTLE_MASTER"."RESI_NO")
and pat_resi_info.admission_time >= '1900-01-01 00:00:00'
and pat_resi_info.admission_time <= '1900-01-01 23:59:59'
这个问题怎么解决