简单问题，我对ACCESS数据库不熟悉，各位帮帮忙，30分 ( 积分: 30 )

darlingpeng · 2007-06-13

msql7:='select * from txt_tmp1 where a0>'''+inttostr(a0)+''' and a0<'''+inttostr(b0)+''' ';
这句话在sql2000中可以执行，在access不能执行，类型不对，
a0是int类型
该怎么写？

darlingpeng · 2007-06-13

有人知道么？

subosoft · 2007-06-13

msql7:='select * from txt_tmp1 where a0>'+quotedstr(a0)+' and a0<'+quotedstr(b0);
试试这个

darlingpeng · 2007-06-13

to
subosoft,
不行，编译都通不过

darlingpeng · 2007-06-13

有哪位大侠知道
帮帮小弟啊

angellover · 2007-06-13

BETWEEN... END

ysai · 2007-06-13

msql7:='select * from txt_tmp1 where a0>'+inttostr(a0)+' and a0<'+inttostr(b0);

angellover · 2007-06-13

晕,类型不对啊,a0是INT,inttostr(a0)是STRINGS啊

darlingpeng · 2007-06-13

to ysai,
谢了，哥们

angellover · 2007-06-13

要用StrTOInt