我引用的是Microsoft ActiveX Data Object 2.8 Library 在Microsoft.Jet.OLEDB.4.0使用ADO Updata命令无效,不能更改相应的记录.
程序如下: Dim cn As ADODB.Connection
Dim rst As ADODB.Recordset
''
Set cn = New ADODB.Connection
cn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& App.Path & "\directory.mdb;"
Set rst = New ADODB.Recordset
rst.Open "pipeline", cn, , , adCmdTable
--------
运行以下二句,出错??
'rst.CursorType = adOpenKeyset
'rst.LockType = adLockOptimistic
这两句是要还是不要
----
rst.MoveFirst
Dim Str_Handle(0 To 6) As String
Dim point1(0 To 2) As Double, point2(0 To 2) As Double, point3() As Double
Dim ii As Integer
ii = 0
Do Until rst.EOF
point1(0) = rst!PointX: point1(1) = rst!PointY: point1(2) = rst!PointZ
rst.MoveNext
If rst.EOF Then
Exit Do
Else
point2(0) = rst!PointX: point2(1) = rst!PointY: point2(2) = rst!PointZ
End If
Set Ent = obj_ModelSpace.addline(point1, point2)
---
我的关键语句,出错,如何解决?
'rst!EntityHandleID = Trim(Ent.Handle)
---
Loop
---
不能运行??
'rst.Update
---
谢谢各位大侠
程序如下: Dim cn As ADODB.Connection
Dim rst As ADODB.Recordset
''
Set cn = New ADODB.Connection
cn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& App.Path & "\directory.mdb;"
Set rst = New ADODB.Recordset
rst.Open "pipeline", cn, , , adCmdTable
--------
运行以下二句,出错??
'rst.CursorType = adOpenKeyset
'rst.LockType = adLockOptimistic
这两句是要还是不要
----
rst.MoveFirst
Dim Str_Handle(0 To 6) As String
Dim point1(0 To 2) As Double, point2(0 To 2) As Double, point3() As Double
Dim ii As Integer
ii = 0
Do Until rst.EOF
point1(0) = rst!PointX: point1(1) = rst!PointY: point1(2) = rst!PointZ
rst.MoveNext
If rst.EOF Then
Exit Do
Else
point2(0) = rst!PointX: point2(1) = rst!PointY: point2(2) = rst!PointZ
End If
Set Ent = obj_ModelSpace.addline(point1, point2)
---
我的关键语句,出错,如何解决?
'rst!EntityHandleID = Trim(Ent.Handle)
---
Loop
---
不能运行??
'rst.Update
---
谢谢各位大侠
解决方案 »
- picture加载图片的方法问题 新手问题照顾哈
- 调用存储过程
- 调用控件的方法时弹出异常“The object invoked has disconnected from its clients.”代表什么意思?如何解决?谢谢。
- VB调用excel
- 超难的问题:如何模拟另一台计算机的键盘输入?
- vb安装问题?
- 如何把一些图标(icon)转成这样的东西???
- 用GetWindowsText得到窗口名后如何得知该窗口的进程?在线等候~~~~~~~~~~~~~UP有分
- 求教如何用VB开发语音卡客户来电系统
- 各位大虾快来抢分菜鸟级问题!!!
- 求教一个控件导致VB退出的问题
- COMMAND控件图片切换,不知道实现这样的效果要用什么事件
上面的rst.Open "pipeline", cn, , , adCmdTable
改为
rst.Open "pipeline", cn, adOpenKeyset, adLockPessimistic
通过,达到目标,
请问各位大侠,能否给解释一下,或提供一网站,让本从慢慢去体会一下.