rs.Open "update User_DoorLock set status_Flag=Flag_Number where fp_id='" + FPID + "'" ' and FPDL_ID='" + FPDLID + "'", cnn, adOpenDynamic, adLockBatchOptimistic运行后可以通过,但是纪录没有更新,是不是语法有误?
我是想运行这样一条SQL:
Update user_doorlock set status_flag="0" where fp_id="L01" and FPDL_ID="XX01"
该怎么写?
我是想运行这样一条SQL:
Update user_doorlock set status_flag="0" where fp_id="L01" and FPDL_ID="XX01"
该怎么写?
rs(2)=要赋予的值
rs.update
使用cnn.execute "update table set 字段=值 where 条件"就可以了,
^_^
1.rst.update
2.cnn.execute
或者你用rst.update来更新