有一个表:czb.db,其中A1字段为字符型(当然全部都是数字了),要求显示在500000到600000之间的数据,下面的语句总是出错,请问我该怎么做
query1.close;
query1.sql.clear;
query1.sql.add('select * from czb where a1>="500000" and a1<="600000"');
query1.open;
query1.close;
query1.sql.clear;
query1.sql.add('select * from czb where a1>="500000" and a1<="600000"');
query1.open;
select * from czb where A1 between '500000' and '600000'
query1.sql.clear;
query1.sql.add('select * from czb where a1>='''+'500000'+''' and a1<='''+'600000'+'''');
query1.open;
select * from czb where a1>:p1 and a1<:p2