例如我想在 ScriptControl 里面aa()的方法支持RecorderSet
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(App.Path & "\test.mdb")
Set rs = db.OpenRecordset("select * from t1")
rs.MoveLast
Text1.Text = "Public Function aa( rs)" & _
"aa = rs.RecordCount " & _
"End Function"
With ScriptControl1
.AddCode (Text1.Text)
Dim v
v = .Run("aa", rs)
MsgBox v
End With
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase(App.Path & "\test.mdb")
Set rs = db.OpenRecordset("select * from t1")
rs.MoveLast
Text1.Text = "Public Function aa( rs)" & _
"aa = rs.RecordCount " & _
"End Function"
With ScriptControl1
.AddCode (Text1.Text)
Dim v
v = .Run("aa", rs)
MsgBox v
End With
解决方案 »
- 如何删除数据表中的重复记录?期待老鸟!!
- winsock控件的dataarrival事件触发问题
- 请教:数据库写入出现的问题
- VB6.0+windows2000操作系统,打包后在有些机器上出现错误 run-time "429" ActiveX component can't create object 请问怎么解决
- internet打包问题,为什么字体文件不能自动安装,链接库文件打包进去后不能自动注册??
- 新手请教:msflexgrid的应用!写数据,保存到文件
- 高分求救:如何在代码窗口中输入和显示泰文?
- 关于数据库安全的问题
- 给大家几本经典的书籍
- 有关资源的组织问题
- 急寻一名精VB编程的人员,报酬面议
- 关于VB的声明DLL的问题
text1.text="function aa()" & vbcrlf & _
"aa = rs.recordcount" & vbcrlf & _
"end function"
另外,如果RS是ADO的对象,则必须设置数据集的游标,即rs.CursorLocation = adUseClient,否则aa=rs.recordcount会出错.