Office中国论坛/Access中国论坛

标题: 恳请各位帮帮忙,在ACCESS中做了一个模糊查询,数据库中没有问题,在VB里调用时查不到 [打印本页]

作者: yrwbc 时间: 2004-5-2 05:29
标题: 恳请各位帮帮忙,在ACCESS中做了一个模糊查询,数据库中没有问题,在VB里调用时查不到
数据库中的查询:

select teacherinfo.duty, teacherinfo.teachername, teacherinfo.teacherintro, teacherinfo.teacherfunction, teacherinfo.photopath
from teacherinfo
where (((teacherinfo.teachername) like "*" & [] & "*"));

vb中的调用:

public function inquires(byval introduction as string) as recordset
dim parnum as integer
cmd.commandtype = adcmdtable
set prm = cmd.createparameter(, advarchar, adparaminput, 60, introduction)
prm.type = advarchar
prm.direction = adparaminput
parnum = len(introduction)
prm.size = parnum
cmd.parameters.append prm

set cmd.activeconnection = cnn1
set inquires = cmd.execute()
end function

各位帮帮忙啊,先谢谢!!!!!!!!!!

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)