rstTemp.Open "select * from T where 序号='" & Number & "' and [page]='1'", Conn, adOpenKeyset, adLockOptimistic
序号='" & Number & "' 你的序号这个字段是字符类型的? 如果是数字类型的话就不要加引号
序号 和 page 如果是数据类型就不能这样写sql假如 序号 是数据类型rstTemp.Open "select * from T where 序号=" & Number & " and page='1'", Conn, adOpenKeyset, adLockOptimistic
你这序号是不是数值型啊 如果是就不要加单引号界定啦rstTemp.Open "select * from T where 序号=" & Number & " and page='1'", Conn, adOpenKeyset, adLockOptimistic'或者 rstTemp.Open "select * from T where 序号='" & trim(cstr(Number)) & "' and page='1'", Conn, adOpenKeyset, adLockOptimistic有可能你这个number转换成字符串后带空格,然后你又加单引号界定,导致SQL中不能正确转换 还page是不是字符型,如果不是就不要加单引号界定了
序号(number)是文本类型,page是长整形
rstTemp.Open "select * from T where 序号='" & Number & "' and page=1", Conn, adOpenKeyset, adLockOptimistic
文本 "select * from my_table where my_name = '" & strName & "' "数字 "select * from my_table where my_id = " & intId access 日期 "select * from my_table where my_date = #" & datToday & "# "
你这序号是不是数值型啊 如果是就不要加单引号界定啦 VB code rstTemp.Open "select * from T where 序号=" & Number & " and page='1'", Conn, adOpenKeyset, adLockOptimistic'或者 rstTemp.Open "select * from T where 序号='" & trim(cstr(Number)) & "' and page='1'", Conn, adOpenKeyset, adLockOptimistic 有可能你这个number转换成字符串后带空格,然后你又加单引号界定,导致SQL中不能正确转换 还page是不是字符型,如果不是就不要加单引号界定了
rstTemp.Open "select * from T where 序号 = '" & Number & "' and page = 1", Conn, adOpenKeyset, adLockOptimistic
你的序号这个字段是字符类型的? 如果是数字类型的话就不要加引号
如果是就不要加单引号界定啦rstTemp.Open "select * from T where 序号=" & Number & " and page='1'", Conn, adOpenKeyset, adLockOptimistic'或者
rstTemp.Open "select * from T where 序号='" & trim(cstr(Number)) & "' and page='1'", Conn, adOpenKeyset, adLockOptimistic有可能你这个number转换成字符串后带空格,然后你又加单引号界定,导致SQL中不能正确转换
还page是不是字符型,如果不是就不要加单引号界定了
"select * from my_table where my_name = '" & strName & "' "数字
"select * from my_table where my_id = " & intId access 日期
"select * from my_table where my_date = #" & datToday & "# "
如果是就不要加单引号界定啦
VB code
rstTemp.Open "select * from T where 序号=" & Number & " and page='1'", Conn, adOpenKeyset, adLockOptimistic'或者
rstTemp.Open "select * from T where 序号='" & trim(cstr(Number)) & "' and page='1'", Conn, adOpenKeyset, adLockOptimistic
有可能你这个number转换成字符串后带空格,然后你又加单引号界定,导致SQL中不能正确转换
还page是不是字符型,如果不是就不要加单引号界定了