哪位大哥帮我看看这句sql有什么错？
conn.execute "INSERT INTO sys_order_action (productid,offerno,brand,customer,qty,sale_price,cs_remark,pic,WEIGHT) SELECT productid,offerno,brand,customer,qty,sale_price,cs_remark,pic,WEIGHT FROM view_order_offer WHERE (id= "&ddid& ") "
作用是把表 view_order_offer 里id=ddid查询出的数据添加到sys_order_action表
[解决办法]
conn.execute "INSERT INTO sys_order_action (productid,offerno,brand,customer,qty,sale_price,cs_remark,pic,WEIGHT) SELECT productid,offerno,brand,customer,qty,sale_price,cs_remark,pic,WEIGHT FROM view_order_offer WHERE [id]= " & ddid & ") "
如ID为字符型：
conn.execute "INSERT INTO sys_order_action (productid,offerno,brand,customer,qty,sale_price,cs_remark,pic,WEIGHT) SELECT productid,offerno,brand,customer,qty,sale_price,cs_remark,pic,WEIGHT FROM view_order_offer WHERE [id]=‘ " & ddid & "’) "
[解决办法]
--所有的字段名加[]，如果ID是数字，参数两侧不需要加单引号，但是如果是字符型，参数两侧需要加单引号：
conn.execute "INSERT INTO sys_order_action ([productid],[offerno],[brand],[customer],[qty],[sale_price],[cs_remark],[pic],[WEIGHT]])
SELECT [productid],[offerno],[brand],[customer],[qty],[sale_price],[cs_remark],[pic],[WEIGHT]
FROM view_order_offer WHERE ([id]= " & ddid & ") "
