with adoquery1 do begin close; sql.clear; sql.add('select * from mydata'); open;
if fieldvalues['username']< >'' then begin button1.Caption := fieldvalues['username'].asstring; username := fieldvalues['username'].asstring; password := fieldvalues['password'].asstring; end; end;
with adoquery1 do begin close; sql.clear; sql.add('select * from mydata'); open;
配对的END没有。 if adoquery1.fieldvalues['username']< > '' then begin button1.Caption := adoquery1.fieldvalues['username'].asstring; username := adoquery1.fieldvalues['username']; password := adoquery1.fieldvalues['password']; end; end;
with adoquery1 do begin close; sql.clear; sql.add('select * from mydata'); open; if not eof then begin if fieldvalues['username']<>null then begin button1.Caption:=fieldvalues['username'].asstring; username:=fieldvalues['username'].asstring; password:=fieldvalues['password'].asstring; end; end; end 这样应该就没有问题了,或者不要用with直接把代码写出来,我是不喜欢用with容易出错!
with adoquery1 do begin close; sql.clear; sql.add('select * from mydata'); open; if not eof then begin if (Fieldbyname('username').Asstring<> nil) and (Fieldbyname('username').asstring<>'') then begin button1.Caption:=Fieldbyname('name').Asstring; username:=Fieldbyname('username').Asstring; password:=Fieldbyname('password').Asstring; end; end; end nil 和'' 不一样最好都加上我建议你不要用FieldValues['name'] 如果要用就应该是with adoquery1 do begin close; sql.clear; sql.add('select * from mydata'); open; if not eof then begin if (FieldValues['name']<> nil) and (FieldValues['name']<>'') then begin button1.Caption:=FieldValues['name']; username:=FieldValues['username']; password:=FieldValues['password']; end; end; end
with adoquery1 do begin close; sql.clear; sql.add('select * from mydata'); open;
if fieldvalues['username']< > '' then begin button1.Caption := fieldvalues['username'].asstring; username := fieldvalues['username'].asstring; password := fieldvalues['password'].asstring; end; end;
即使有记录满足搜索条件,password的值也可能为空,所以…………
begin
close;
sql.clear;
sql.add('select * from mydata');
open;
if fieldvalues['username']< >'' then
begin
button1.Caption := fieldvalues['username'].asstring;
username := fieldvalues['username'].asstring;
password := fieldvalues['password'].asstring;
end;
end;
begin
close;
sql.clear;
sql.add('select * from mydata');
open;
配对的END没有。 if adoquery1.fieldvalues['username']< > '' then
begin
button1.Caption := adoquery1.fieldvalues['username'].asstring;
username := adoquery1.fieldvalues['username'];
password := adoquery1.fieldvalues['password'];
end;
end;
begin
close;
sql.clear;
sql.add('select * from mydata');
open;
if not eof then
begin
if fieldvalues['username']<>null then
begin
button1.Caption:=fieldvalues['username'].asstring;
username:=fieldvalues['username'].asstring;
password:=fieldvalues['password'].asstring;
end;
end;
end
这样应该就没有问题了,或者不要用with直接把代码写出来,我是不喜欢用with容易出错!
begin
close;
sql.clear;
sql.add('select * from mydata');
open;
if not eof then
begin
if (Fieldbyname('username').Asstring<> nil) and (Fieldbyname('username').asstring<>'') then
begin
button1.Caption:=Fieldbyname('name').Asstring;
username:=Fieldbyname('username').Asstring;
password:=Fieldbyname('password').Asstring;
end;
end;
end
nil 和'' 不一样最好都加上我建议你不要用FieldValues['name']
如果要用就应该是with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from mydata');
open; if not eof then
begin
if (FieldValues['name']<> nil) and (FieldValues['name']<>'') then
begin
button1.Caption:=FieldValues['name'];
username:=FieldValues['username'];
password:=FieldValues['password'];
end;
end;
end
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from mydata');
open;
if fieldvalues['username']< > '' then
begin
button1.Caption := fieldvalues['username'].asstring;
username := fieldvalues['username'].asstring;
password := fieldvalues['password'].asstring;
end;
end;
后面加上
if recordcont=0 then exit;