procedure TForm1.but_runClick(Sender: TObject);
var
content:string;
begin
try
with datamoduleado.ADOQuery1 do
begin
content:=edit_ID.Text;
sql.Clear;
sql.Add('select * from book where ID like :edit_ID ');
parameters.ParamByName('edit_ID').Value:=content;
open;
first;
Edit_tel.Text:=fieldbyname('tel').AsString;
Edit_fax.Text:=fieldbyname('fax').AsString;
end;
except
messagedlg('查询失败',mterror,[mbok],0);
end;
end;我想在点“下一个”的button时,在edit_tel和edit_fax的对话框中显示出下一个同样ID的数据库中的记录。
var
content:string;
begin
try
with datamoduleado.ADOQuery1 do
begin
content:=edit_ID.Text;
sql.Clear;
sql.Add('select * from book where ID like :edit_ID ');
parameters.ParamByName('edit_ID').Value:=content;
open;
first;
Edit_tel.Text:=fieldbyname('tel').AsString;
Edit_fax.Text:=fieldbyname('fax').AsString;
end;
except
messagedlg('查询失败',mterror,[mbok],0);
end;
end;我想在点“下一个”的button时,在edit_tel和edit_fax的对话框中显示出下一个同样ID的数据库中的记录。
3q3q
procedure TForm1.But_nextClick(Sender: TObject);
begin
DataModuleADO.ADOQuery1.Next;
end;可是点了还没反应
begin
DataModuleADO.ADOQuery1.Next;
end;可是点了还没反应
close; //试试看
Edit_tel.Text:=fieldbyname('tel').AsString;
Edit_fax.Text:=fieldbyname('fax').AsString;
Edit_tel.Text:=fieldbyname('tel').AsString;
Edit_fax.Text:=fieldbyname('fax').AsString;