PB6.5语句的问题
string s_sql
s_sql='select f_initamt,f_pubamt,f_impamt,f_backamt,f_consumeamt,f_finalamt,s_depno from d_rep_depositjxc where s_repdt>='+em_sdate.text+'and s_repdt<='+em_edate.text
dw_1.setsqlselect(s_sql)
dw_1.settransobject(sqlca)
dw_1.retrieve()
请问如何把em_sdate.text和em_edate.text转成字符型的...现在我写的语句运行后是会出现的
[解决办法]
s_sql="select f_initamt,f_pubamt,f_impamt,f_backamt,f_consumeamt,f_finalamt,s_depno from d_rep_depositjxc where s_repdt>='"+em_sdate.text+'" and s_repdt <='"+em_edate.text +"'"
[解决办法]
string+引号？呵~~~
