这个意思? With ADOQuery1 Do Begin Close; Sql.clear; Sql.Text:='Select * From A'; Open; If FieldByName('State').Asstring='开' Then Begin Label1.Caption:=FieldByName('windspeed').Asstring; Label2.Caption:=FieldByName('temperature').Asstring; End; End;
谢谢楼上两位,不过我写在FormCeate里面没啥放映啊procedure TForm1.FormCreate(Sender: TObject); begin with adoquery1 do begin close; sql.Clear; sql.Add('select state from aircondition where ID=0'); open; if FieldByName('State').Asstring='1' then begin Label8.Caption:=FieldByName('Currenttemp').Asstring; Label9.Caption:=FieldByName('SetTemp').Asstring; Label10.Caption:=FieldByName('WindSpeed').Asstring; Label11.Caption:=FieldByName('humidity').Asstring; end; end;end;
procedure TForm1.FormCreate(Sender: TObject); begin with adoquery1 do begin close; sql.Clear; sql.Add('select state from aircondition where ID=0'); open; ShowMessage(FieldByName('State').Asstring); //--------------先打印出来是什么东东 if FieldByName('State').Asstring='1' then begin Label8.Caption:=FieldByName('Currenttemp').Asstring; Label9.Caption:=FieldByName('SetTemp').Asstring; Label10.Caption:=FieldByName('WindSpeed').Asstring; Label11.Caption:=FieldByName('humidity').Asstring; end; end;end;
检查一下'select state from aircondition where ID=0'这个语句返回的记录有几条
With ADOQuery1 Do
Begin
Close;
Sql.clear;
Sql.Text:='Select * From A';
Open;
If FieldByName('State').Asstring='开' Then
Begin
Label1.Caption:=FieldByName('windspeed').Asstring;
Label2.Caption:=FieldByName('temperature').Asstring;
End;
End;
begin
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select state from aircondition where ID=0');
open;
if FieldByName('State').Asstring='1' then
begin
Label8.Caption:=FieldByName('Currenttemp').Asstring;
Label9.Caption:=FieldByName('SetTemp').Asstring;
Label10.Caption:=FieldByName('WindSpeed').Asstring;
Label11.Caption:=FieldByName('humidity').Asstring;
end;
end;end;
您这样做仅仅是对aircondition表第一条记录进行判断,有意义吗?
这部分程序是用来管理空调的。
当程序开始运行时,如果空调开着就把空调的一些参数显示出来(用Label显示),可惜我调试了半天就是没反映,既没错误也没显示,写在OnShow里也不行啊,是不是上面那代码要改进啊?
begin
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select state from aircondition where ID=0');
open;
ShowMessage(FieldByName('State').Asstring); //--------------先打印出来是什么东东
if FieldByName('State').Asstring='1' then
begin
Label8.Caption:=FieldByName('Currenttemp').Asstring;
Label9.Caption:=FieldByName('SetTemp').Asstring;
Label10.Caption:=FieldByName('WindSpeed').Asstring;
Label11.Caption:=FieldByName('humidity').Asstring;
end;
end;end;