adoquery 查询结果修改，，急！！！！

Question

我想修改用adoquery查询出来的结果中的2个字段。。
该怎么写？
adoquery1.edit;
adoquery1['huanshudate']:=DateTimePicker1.Date;
adoquery1.post;
adoquery1.Close;
adoquery1.Open;
提示；；；缺少有效的定位信息

Answer 1

adoquery1['huanshudate']:=DateTimePicker1.Date;=>
adoquery1.field['huanshudate']:=DateTimePicker1.Date;

Answer 2

adoquery1['huanshudate']:=DateTimePicker1.Date;=>
adoquery1.fieldsvalue['huanshudate']:=DateTimePicker1.Date;

Answer 3

adoquery1.fieldbyname('huanshudate').asdatetime:=DateTimePicker1.Datetime;
adoquery1.fields['huanshudate'].values:=DateTimePicker1.Datetime;

Answer 4

with adoquery1 do
begin
  Open;
  sql.text:='update yourtable set huanshudate='''+DateTimePicker1.Datetime+''''
  execsql;  
end

Answer 5

huanshudate='''+DateTimePicker1.Datetime+''''???

Answer 6

adoquery1.fields['huanshudate'].values:=DateTimePicker1.Date

Answer 7

在adoquery的sql语句中要select出的字段中要包括主键字段