with query1 do
close;
sql.clear;
sql.select a1,b1,c1 from table1 where number = 1;
open;第一次,我要显示number=1 的各个字段;第二次,我想同时在DBgrid中显示number=1和number=5 的各个字段,怎么实现?
close;
sql.clear;
sql.select a1,b1,c1 from table1 where number = 1;
open;第一次,我要显示number=1 的各个字段;第二次,我想同时在DBgrid中显示number=1和number=5 的各个字段,怎么实现?
close;
sql.clear;
sql.add(select a1,b1,c1 from table1 where number = 1 union select a1,b1,c1 from table1 where number = 5);
open;
close;
sql.clear;
sql.add(select a1,b1,c1 from table1 where number = 1 or number = 5 order by number);
open;
没输入一次条件就在后面加上一个条件字符串
sql.add( 'or number=:vnumber');
parameters.paramByname('vnumber').value:=yourNumber;最后加上
sql.add('order by number');
var
K := 0
if k = 0 then
begin
sql.add(select a1,b1,c1 from table1 where number = 1);
end
else
begin
sql.add(select a1,b1,c1 from table1 where number = 1 union all select a1,b1,c1 from table1 where number = 5);
K = K + 1; end;
where Number in(1,5)