L lzh1018 Unregistered / Unconfirmed GUEST, unregistred user! 2007-11-21 #1 我想只显示"id"字段为10-30,或20-45的数据,请问如何写?因为很菜,请附代码,分只有这么多了,希望不要嫌少,非常感谢!
S shadowpj Unregistered / Unconfirmed GUEST, unregistred user! 2007-11-21 #4 把ADOTABLE换成ADOQUERY with adoquery1 do begin close; sql.clear; sql.add('select * from 表 where id between 10 and 30'); open; end; 大概就是这样哦。还是看书学基础好些~
把ADOTABLE换成ADOQUERY with adoquery1 do begin close; sql.clear; sql.add('select * from 表 where id between 10 and 30'); open; end; 大概就是这样哦。还是看书学基础好些~
L lovedesky Unregistered / Unconfirmed GUEST, unregistred user! 2007-11-21 #5 10-30和20-45之间有交集吧，不就是10-45吗？
贝 贝尔 Unregistered / Unconfirmed GUEST, unregistred user! 2007-11-22 #6 with adoquery1 do begin close; sql.clear; sql.add('select * from 表 where id between 10 and 45'); open; end;
with adoquery1 do begin close; sql.clear; sql.add('select * from 表 where id between 10 and 45'); open; end;
R rtl Unregistered / Unconfirmed GUEST, unregistred user! 2007-11-22 #7 用 where in 子句 ------------------------------------------------------ http://www.waibaoinfo.com 外包信息网
