改成这样,Order by必须放到最后 with dm_kehu.ADO_chaxun_Query do begin Close ; SQL.Clear ; SQL.Add ('select * from kehu_dj where 1=1 '); if kehu_bm<>'' then begin sql.Add ('and kehu_bm like :kehu_bm'); parameters.parambyname('kehu_bm').value:='%'+kehu_bm + '%'; end; SQL.Add ('order by dengji_sj asc');
顺序问题,改:with dm_kehu.ADO_chaxun_Query do begin Close ; SQL.Clear ; SQL.Add ('select * from kehu_dj where 1=1 '); if kehu_bm<>'' then begin sql.Add ('and kehu_bm like :kehu_bm'); parameters.parambyname('kehu_bm').value:='%'+kehu_bm + '%'; end; SQL.Add ('order by dengji_sj asc');
with dm_kehu.ADO_chaxun_Query do
begin
Close ;
SQL.Clear ;
SQL.Add ('select * from kehu_dj where 1=1 ');
if kehu_bm<>'' then
begin
sql.Add ('and kehu_bm like :kehu_bm');
parameters.parambyname('kehu_bm').value:='%'+kehu_bm + '%';
end;
SQL.Add ('order by dengji_sj asc');
begin
Close ;
SQL.Clear ;
SQL.Add ('select * from kehu_dj where 1=1 ');
if kehu_bm<>'' then
begin
sql.Add ('and kehu_bm like :kehu_bm');
parameters.parambyname('kehu_bm').value:='%'+kehu_bm + '%';
end;
SQL.Add ('order by dengji_sj asc');