在字段编辑器中新建一字段x设为计算字段 在dataset的计算事件中 with adoquery do begin close; sql.text:='select name from dmb where dm='+''''+dataset.fieldbyname('dm').asstring+''''; open; dataset.fieldbyname('x').asstring:=fields[0].asstring; end;
另外在代码字段的gettext事件中与是可以的,原理一样 if sender.asstrin<>''then beginwith query do begin close; sql.clear; sql.text:=sql.text:='select name from dmb where dm='+''''+sender.text+''''; open; text:=fields[0].asstring; end; end;
在dataset的计算事件中
with adoquery do
begin
close;
sql.text:='select name from dmb where dm='+''''+dataset.fieldbyname('dm').asstring+'''';
open;
dataset.fieldbyname('x').asstring:=fields[0].asstring;
end;
if sender.asstrin<>''then
beginwith query do
begin
close;
sql.clear;
sql.text:=sql.text:='select name from dmb where dm='+''''+sender.text+'''';
open;
text:=fields[0].asstring;
end;
end;