标题:SQL 语句提示类型出错
只看楼主
yuk_yu
Rank: 3Rank: 3
等 级:论坛游侠
帖 子:334
专家分:134
注 册:2009-3-16
结帖率:85.71%
 问题点数:0 回复次数:1 
SQL 语句提示类型出错
我反复调试了怎么总出错?


me.text1(0)=05/31/2014
me.text1(0)="1,1,1,0,1,0,0,1"
UserID = 123
SQL = " Update Usermanagement set 有效期 =  # " +  me.text1(0) "# ," + " 权限 = '" + me.text1(1) + " ' where ID = " + UserID
搜索更多相关主题的帖子: where 有效期 
2014-05-30 17:13
yuk_yu
Rank: 3Rank: 3
等 级:论坛游侠
帖 子:334
专家分:134
注 册:2009-3-16
得分:0 
回复 楼主 yuk_yu
已解决:

  SQL = "Update Usermanagement set FunctionAuthotized = '" + Auth + "', " + "[Validperiod] = # " + Me.Text1(3) + "# where ID = " & SelectID

谢谢大家!!
2014-05-30 17:35



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-432285-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.400623 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved