delphi+ODAC:ToraQuery + ToraUpdateSQL
有点长,请耐心看完 :)
qryHouseParent(ToraQuery 控件)SQL语句为:
select userid,username,userage from users
qryHouseParent属性Updateobject 设置为:UpdateSQL1(ToraUpdateSQL 控件)
UpdateSQL1的insertL语句:
insert into userparent(userid, userage) values(:userid,:username)(注:userparent表只有这两个字段)
源码:
qryHouseParent.Append;
qryHouseParent.FieldByName('FParentID').AsString := ParentList.Strings[cbxParent.ItemIndex];
qryHouseParent.FieldByName('HouseCode').AsString := fmSysOption.HouseCode;
qryHouseParent.Post;
Post时报错:Field‘username’ must have a value.
这个程序原为BDE连接,后通过BDE Migration Wizard将程序转换成了ODAC的连接方式。
用BDE连接时,插入正常,不报错.
请教原因以及解决方法!