最近编一个物资管理系统,用vb6.0+sqlserver2000,在编写executesql函数时出错,
public function executesql(byval sql as string, msgstring as string) as adodb.recordset
dim cnn as adodb.connection
dim rst as adodb.recordset
dim stokens() as string
on error goto executesql_error
stokens = split(sql)
set cnn = new adodb.connection
cnn.open connectstring
if instr("insert,delete,update", ucase$(stokens(0))) then
cnn.execute sql
msgstring = stokens(0) & "query sucessful"
else
set rst = new adodb.recordset
rst.open trim$(sql), cnn, adopenkeyset, adlockoptimistic
set executesql = rst
msgstring = "查询到" & rst.recordcount & "条记录"
end if
executesql_exit
set rst = nothing
set cnn = nothing
exit function
executesql_error
msgstring = "查询错误" & err.description
resume executesql_exit
end function
public function connectstring() as string
connectstring = "filedsn=material.dsn;uid=sa;pwd=sa"
end function
预编译执行时出现错误,提示子程序或函数未定义,而且光标指向 executesql_exit,我已经把microsoft activex objects 2.6 library 添加了,数据源也设好了
菜鸟学堂:新闻热点
疑难解答