Question

问ADOQuery1:Missing SQL Property出错在哪里啊？附上源程序

procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery1.Open;
adoquery1.Append;
adoquery1.SQL.Add('select * from FP where XLH = ''1');
ADOQUERY1.Open;
ADOQUERY1.First;
LABEL18.Caption:= adoquery1.FieldByName('FPHM').AsString;
adoquery1.Post;
beep;
edit3.Text:=inttostr(strtoint(edit3.Text)+1);
end;

Answer 1

SQL语句少了两个引号﹐改成下面这样
adoquery1.SQL.Add('select * from FP where XLH = ''1''');