Public Zf As ADODB.Connection
Public Jlj_Lsxf As ADODB.Recordset
Jlj_Lsxf.Open "select * from xfb where xfb.name=joe", Zf '到这个语句就出错了!
Jlj_Lsxf.Open "select * from xfb",ZF '这样写就不会错!可见是后面where语句写得方式有问题,请教后面查找条件该怎样写?
Public Jlj_Lsxf As ADODB.Recordset
Jlj_Lsxf.Open "select * from xfb where xfb.name=joe", Zf '到这个语句就出错了!
Jlj_Lsxf.Open "select * from xfb",ZF '这样写就不会错!可见是后面where语句写得方式有问题,请教后面查找条件该怎样写?
Jlj_Lsxf.Open "select * from xfb where xfb.name='joe'", Zf
要改为Jlj_Lsxf.Open "select * from xfb where xfb.name=‘joe’", Zf
如果数据库中的字段为字符型,一定要加一个‘’才能正确查询