您所在位置：主题：求教一个关于数据窗口查询的问题
lujeson
[专家分：0] 发布于 2008-11-01 14:42:00
[size=6][size=5][size=3][size=2]下面的程序不可以查询，查询不出任何结果
string str_tire_spec
str_tire_spec =trim (ddlb_1.text )
String ls_select
ls_select="SELECT id, tire_spec,tire_id, bottom_value, up_value, static_value, even_value, measure_time FROM not_balance WHERE (tire_spec='str_tire_spec')"
dw_1.settrans (sqlca)
dw_1.setsqlselect (ls_select)
dw_1.retrieve ()
但是当WHERE (tire_spec='str_tire_spec')" 改为 WHERE (tire_spec = [b]'10.00R20 '[/b])就可以查询了，不知道什么地方错了。[/size][/size][/size][/size]
string str_tire_spec
str_tire_spec =trim (ddlb_1.text )
String ls_select
ls_select="SELECT id, tire_spec,tire_id, bottom_value, up_value, static_value, even_value, measure_time FROM not_balance WHERE (tire_spec='str_tire_spec')"
dw_1.settrans (sqlca)
dw_1.setsqlselect (ls_select)
dw_1.retrieve ()
但是当WHERE (tire_spec='str_tire_spec')" 改为 WHERE (tire_spec = [b]'10.00R20 '[/b])就可以查询了，不知道什么地方错了。[/size][/size][/size][/size]