sql更新问题update[M_use]setM_log_num(selectcount(id)from[M_log]whereM_useid &session( M_login_u
sql更新问题
update [M_use] set M_log_num=(select count(id) from [M_log] where M_useid= "&session( "M_login_useid ")& ") where id= "&session( "M_login_useid ")
请问这句哪里有错吖??
[解决办法]
JET SQL不支持这种写法
在ACCESS中
update [M_use] set M_log_num=dcount( "id ", "[M_log] ", "M_useid= & session( "M_login_useid ")) where id= " & session( "M_login_useid ")
否则生成临时表，再替换