大家看看,为什么一执行就死机? procedure TForm1.DBEdit3KeyPress(Sender: TObject; var Key: Char); begin table2.First; if dbedit3.text<>' then begin repeat table2.next; until trim(dbedit3.Text)=table2.FieldByName('type').AsString; end; dbedit1.Text:=table2.fieldbyname('code').AsString; dbedit2.Text:=table2.fieldbyname('name').AsString; end;
----------------------------------------------
命运是一只沦落在鸡窝里的鹰
procedure TForm1.DBEdit3Exit(Sender: TObject; var Key: Char); begin //table2.First; if dbedit3.text<>' then begin {repeat table2.next; until trim(dbedit3.Text)=table2.FieldByName('type').AsString;} if table2.Locate('type',VarArrayof[trim(dbedit3.Text)],[loPartialKey]) then begin dbedit1.Text:=table2.fieldbyname('code').AsString; dbedit2.Text:=table2.fieldbyname('name').AsString; end else begin MessageBox(Handle,'未发现符合条件的记录!',提示',MB_OK+MB_ICONEXCLAMATION); dbedit3.SetFocus; end; end; end;