请教access链接sql执行update语法
如下语句,会提示[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
update t_system as t1,t_system as t2 IN ODBC[ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=chnyo2009;database=his_chnyo2] set t1.sl=t2.sl,t1.je=t2.je,t1.xmz=t2.xmz,t1.bz=t2.bz,t1.rq=t2.rq,t1.bz2=t2.bz2 WHERE t1.bh =t2.bh and t1.modidate>#2000-01-01 00:00:00# and t1.regid=1
在去掉最后面的“and t1.regid=1”后可以成功执行
但在t1表也就是access中的t_system中确实存在列 regid ,在sql的表t_system t2中没有此列
怎么还报错呢?
考虑到access方便性才用它来做个本地缓存的,实在不行就换其他数据库了
update t_system as t1 INNER JOIN
[ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=chnyo2009;database=his_chnyo2].t_system as t2
ON t1.bh =t2.bh
set T1.sl=t2.sl,t1.je=t2.je,t1.xmz=t2.xmz,t1.bz=t2.bz,t1.rq=t2.rq,t1.bz2=t2.bz2 WHERE t1.modidate>#2000-01-01 00:00:00# and t1.regid=1
直接在ACCESS中运行
update t_system as t1,t_system as t2 IN ODBC[ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=chnyo2009;database=his_chnyo2] set t1.sl=t2.sl,t1.je=t2.je,t1.xmz=t2.xmz,t1.bz=t2.bz,t1.rq=t2.rq,t1.bz2=t2.bz2 WHERE t1.bh =t2.bh and t1.modidate>#2000-01-01 00:00:00# and t1.regid=1直接在ACCESS的查询中执行一下这个SQL语句,应该不象是语句的问题,检查一下程序代码。