procedure TForm1.Button1Click(Sender: TObject);
begin
with Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from m_jbqk where rydm like :rydm and jh like :jh');
Params.Items[0].AsString := '%' + Edit1.Text + '%';
Params.Items[1].AsString := '%' + Combobox1.Text + '%';
PrePare;
Open;
end;
end;
呵呵,看一下,可以通过;
begin
with Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from m_jbqk where rydm like :rydm and jh like :jh');
Params.Items[0].AsString := '%' + Edit1.Text + '%';
Params.Items[1].AsString := '%' + Combobox1.Text + '%';
PrePare;
Open;
end;
end;
呵呵,看一下,可以通过;
begin
with Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from m_jbqk where rydm like :rydm and jh like :jh and bm like :bm');
Params.Items[0].AsString := '%'+Edit1.Text + '%';
Params.Items[1].AsString := '%' + Combobox1.Text + '%';
Params.Items[2].AsString := '%' + Edit2.Text + '%';
PrePare;
Open;
end;
对了,你的错是什么啊?
" SQL.Add('select * from m_jbqk where rydm like :rydm and jh=:jh');
Params.Items[0].AsString := '%'+Edit1.Text + '%';
Params.Items[1].AsString := Trim(Combobox1.Text);
"
我要的语句应该是这样写,可是结果却出不来.