sqlstr = "select * from xxxx where LOWER(yyyy) = 'zzzz'"
或
sqlstr="select * from xxxx where (select lower(yyyy) from xxxx)='zzzz'"
试试看
或
sqlstr="select * from xxxx where (select lower(yyyy) from xxxx)='zzzz'"
试试看
dim tempstr as string
link.ConnectionString =省略,但肯定正确
link.Open
tempstr=LOWER(yyyy)
Set recordone = New ADODB.Recordset
sqlstr = "select * from xxxx where tempstr= zzzz"
Set recordone = link.Execute(sqlstr)
dim tempstr as string
link.ConnectionString =省略,但肯定正确
link.Open
tempstr=Lcase(yyyy) 'lcase()是VB中提供的函数
Set recordone = New ADODB.Recordset
sqlstr = "select * from xxxx where tempstr= zzzz"
Set recordone = link.Execute(sqlstr)
Access不支持Lower()函数,用其他函数代替,事实上你的情况可以直接去掉lower,字段名事不区分大小写的(Access中)