procedure TForm1.Button1Click(Sender: TObject); begin with adoquery1 do begin close; sql.Text:='select 1 from 表名 where 字段名='''+edit1.Text+''''; open; if IsEmpty then showmessage('没有') else showmessage('有') ; end;end;
with adoquery1 do begin close; sql.Text:='select * from 表名 where 字段名='''+edit1.Text+''''; open; end; if adoquery1.eof then showmessage('没有'); else showmessage('有') ;
with adoquery1 do begin close; sql.Text:='select * from 表名 where 字段名=:pp'; parameters.parambyname('pp').value := trim(edit1.text); open; end; if adoquery1.eof then showmessage('没有'); else showmessage('有') ;
procedure TForm1.Button1Click(Sender: TObject);
begin
with adoquery1 do begin
close;
sql.Text:='select 1 from 表名 where 字段名='''+edit1.Text+'''';
open;
if IsEmpty then
showmessage('没有')
else
showmessage('有') ;
end;end;
begin
close;
sql.Text:='select * from 表名 where 字段名='''+edit1.Text+'''';
open;
end;
if adoquery1.eof then
showmessage('没有');
else
showmessage('有') ;
begin
close;
sql.Text:='select * from 表名 where 字段名=:pp';
parameters.parambyname('pp').value := trim(edit1.text);
open;
end;
if adoquery1.eof then
showmessage('没有');
else
showmessage('有') ;