TQuery+TUpdateSQL+access2000的问题

frankchp 2003-05-14 12:03:33
无法插入、修改、但可以删除,请问为什么?
TUpdateSQL的SQL语句:
update RecRecordTable
set
Address = :Address,
Name = :Name,
Number = :Number,
unit = :unit,
Leng = :Leng,
Width = :Width,
Height = :Height,
other = :other,
Total = :Total,
Estimate = :Estimate,
Remark = :Remark,
BudgetID = :BudgetID,
PrePrice = :PrePrice,
Coefficient = :Coefficient,
PerWorkPrice = :PerWorkPrice,
PerDay = :PerDay,
GoodNum = :GoodNum,
GoodProDay = :GoodProDay
where
ProjectID = :OLD_ProjectID and
RecID = :OLD_RecID
insert into RecRecordTable
(ProjectID, RecID, Address, Name, Number, unit, Leng, Width, Height,
other, Total, Estimate, Remark, BudgetID, PrePrice, Coefficient, PerWorkPrice,
PerDay, GoodNum, GoodProDay)
values
(:ProjectID, :RecID, :Address, :Name, :Number, :unit, :Leng, :Width,
:Height, :other, :Total, :Estimate, :Remark, :BudgetID, :PrePrice, :Coefficient,
:PerWorkPrice, :PerDay, :GoodNum, :GoodProDay)
delete from RecRecordTable
where
ProjectID = :OLD_ProjectID and
RecID = :OLD_RecID

...全文
21 点赞 收藏 回复
写回复
回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
相关推荐
发帖
网络通信/分布式开发
创建于2007-08-02

1575

社区成员

Delphi 网络通信/分布式开发
申请成为版主
帖子事件
创建了帖子
2003-05-14 12:03
社区公告
暂无公告