Question

delphi+access update 更新多条字段

update 常规投入合计表 set 种植面积合计=SumTable.种植面积合计,种子总量合计=SumTable.种子总量合计,种子成本合计=SumTable.种子成本合计,地膜总量合计=SumTable.地膜总量合计,地膜成本合计=SumTable.地膜成本合计,
肥料总量合计=SumTable.肥料总量合计,肥料成本合计=SumTable.肥料成本合计,灌水总量合计=SumTable.灌水总量合计,灌水成本合计=SumTable.灌水成本合计,燃料动力总量合计=SumTable.燃料动力总量合计,
燃料动力成本合计=SumTable.燃料动力成本合计,农药成本合计=SumTable.农药成本合计,机械作业成本合计=SumTable.机械作业成本合计,雇工成本合计=SumTable.雇工成本合计,收割成本合计=SumTable.收割成本合计,
种植投入合计=SumTable.种植投入合计 from 常规投入合计表 inner join (select 作物名称,技术模式,sum(种植面积) as 种植面积合计,sum(种子总量) as 种子总量合计,sum(种子成本) as 种子成本合计,
sum(地膜总量) as 地膜总量合计,sum(地膜成本) as 地膜成本合计,sum(肥料总量) as 肥料总量合计,sum(肥料成本) as 肥料成本合计,sum(灌水总量) as 灌水总量合计,sum(灌水成本) as 灌水成本合计,
sum(燃料动力总量) as 燃料动力总量合计 ,sum(燃料动力成本) as 燃料动力成本合计,sum(农药成本) as 农药成本合计,sum(机械作业成本) as 机械作业成本合计,sum(雇工成本) as 雇工成本合计,sum(收割成本) as 收割成本合计,sum(滴灌带成本) as 滴灌带成本合计,
sum(成本合计) as 种植投入合计 from 常规投入表 group by 作物名称,技术模式) SumTable on SumTable.技术模式=常规投入合计表.技术模式 and SumTable.作物名称=常规投入合计表.作物名称
查询分析器里执行正常，delphi+access下拼接后报错，是不是这条语句在access下运行不了，请大哥大姐们给指点下，谢谢

Answer 1

你拿sql server的代码在access里执行是会有麻烦的，access里面有代码测试运行的地方，你试试再说

Answer 2

一条的POST做循环吧，ACCESS貌似不支持批量操作吧