qry1.close;
qrey1.sql.text := 'select * for 你的表 where '+
'字段1='''+edit1.text+'''';//字段1的类型为字符型,否则为
'字段1='+edit1.text;
qry1.open;
qrey1.sql.text := 'select * for 你的表 where '+
'字段1='''+edit1.text+'''';//字段1的类型为字符型,否则为
'字段1='+edit1.text;
qry1.open;
begin
Query1.SQL.Clear;
Query1.SQL.Text := 'select * from xxx where aa = ' +
QuotedStr(Edit1.Text);
// xxx/aa 是你要查询的表和字段
Query1.Open;
end;
IF query1.Locate(query1.fields[i].value,edit1.text,[loPartialKey]) THEN exit;
var i:integer;
begin
i:=0;
result:=false;
for i:=0 to query1.FieldCount-1
IF query1.Locate(query1.fields[i].FieldName,edit1.text,[loPartialKey]) THEN
begin
result:=true;
exit;
end;
result:=false;
end;
procedure TForm1.Edit1Change(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from employee where lastName like '+
QuotedStr(edit1.text+'%') );
query1.Open;
end;如果被查詢表的記錄不是非常多的話,用Filter效果會好很多
procedure TForm1.Edit1Change(Sender: TObject);
begin
query1.Filter:='lastName='+QuotedStr(Edit1.Text+'*');
query1.Filtered:=true;
end;
如果在网络环境下会记录数目很多会很慢很慢~~~~