我建了一个Access数据库,里面的字段有:ID Pname Psex 等等
我用:
Dim SerKey As Long
DBSource = "Select * from Pdata1 where ID='" & SerKey & "'" 'ID为自动编号,长整型
Set perRS = New Recordset
perRS.Open DBSource, DB, adOpenDynamic, adLockOptimistic
提示数据类型出错
Dim SerKey As String
DBSource = "Select * from Pdata1 where Pname='" & SerKey & "'" 'Pname为字符型
Set perRS = New Recordset
perRS.Open DBSource, DB, adOpenDynamic, adLockOptimistic
就没有问题。
请问怎么回事儿?急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急!
我用:
Dim SerKey As Long
DBSource = "Select * from Pdata1 where ID='" & SerKey & "'" 'ID为自动编号,长整型
Set perRS = New Recordset
perRS.Open DBSource, DB, adOpenDynamic, adLockOptimistic
提示数据类型出错
Dim SerKey As String
DBSource = "Select * from Pdata1 where Pname='" & SerKey & "'" 'Pname为字符型
Set perRS = New Recordset
perRS.Open DBSource, DB, adOpenDynamic, adLockOptimistic
就没有问题。
请问怎么回事儿?急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货