以下是引用onesex在2004-2-22 21:43:35的发言:
Dim mRs
Set mRs=Conn.ExeCute("Select Title,Popedom,RoleTitle,Lock,NickName,ClassPopedom,ClassId From View_AdminInfo Where UCase(Title)='" & UCase(mTitle) & "' And Pwd='" & mPwd &"'")
这句话原来是用在access2000的数据库的,现在我改用SQL2000,所以会出现“[Microsoft][ODBC SQL Server Driver][SQL Server]'UCase' is not a recognized function name. "错误。
请问该怎样改才行呢?请教
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |