我想修改用adoquery查询出来的结果中的2个字段。。
该怎么写?
adoquery1.edit;
adoquery1['huanshudate']:=DateTimePicker1.Date;
adoquery1.post;
adoquery1.Close;
adoquery1.Open;
提示;;;缺少有效的定位信息
该怎么写?
adoquery1.edit;
adoquery1['huanshudate']:=DateTimePicker1.Date;
adoquery1.post;
adoquery1.Close;
adoquery1.Open;
提示;;;缺少有效的定位信息
adoquery1.field['huanshudate']:=DateTimePicker1.Date;
adoquery1.fieldsvalue['huanshudate']:=DateTimePicker1.Date;
adoquery1.fields['huanshudate'].values:=DateTimePicker1.Datetime;
begin
Open;
sql.text:='update yourtable set huanshudate='''+DateTimePicker1.Datetime+''''
execsql;
end