select "No" from liii.db where "No"=:numquery1.parambyname(no).value:='hello,不知这样可行'
这样写: select No from liii.db where No=:num
应该这样写: query.sql.clear; query.sql.add('select no from liii.db') query.sql.add(' where no=:num'); query.parambyname('num').asinteger:=num; query.open;
query.sql.clear; query.sql.add('select no from liii.db') query.sql.add(' where no='''+VAR+'''');//字符型 query.sql.add(' where no='+VAR+'');//数值型 query.open;
where ":No"=num
where "No"=:numquery1.parambyname(no).value:='hello,不知这样可行'
select No from liii.db
where No=:num
query.sql.clear;
query.sql.add('select no from liii.db')
query.sql.add(' where no=:num');
query.parambyname('num').asinteger:=num;
query.open;
query.sql.add('select no from liii.db')
query.sql.add(' where no='''+VAR+'''');//字符型
query.sql.add(' where no='+VAR+'');//数值型
query.open;