Set rs2 = New ADODB.Recordset
rs2.Open "abc", cn, , , adCmdTable.....
rs2.Fields("year") = Combo1.Text
.......错误提示:当前记录集不支持更新...... 应该如何修改 谢谢了
rs2.Open "abc", cn, , , adCmdTable.....
rs2.Fields("year") = Combo1.Text
.......错误提示:当前记录集不支持更新...... 应该如何修改 谢谢了
解决方案 »
- 关于用VB实现合并两个word文档,且保持格式不变
- 老马 我难受^^^^^^
- 如何把我选中的文字的前面都统一添加“//”
- str$()这个函数的作用是什么?
- 关于RichTextBox中字间距问题
- ~~~~~~~~~~~~~ 急需能装在2000系统下的 DCOM98.exe ~~~~~~~~~~~~~~~~~~~~~~
- 有没有一个API可以改变窗口的背景和前景色?
- 请问Access2000中的"加/解密数据库"有什么作用?
- 如何把imagelist中的图片添加到imagecombo中去
- 如何把窗体中的菜单结构放入TREEVIEW控件中?
- VB初学请教:静态字符串将其倒置输出的写法(注:不使用函数)
- Recordset与MSHFlexGrid绑定问题!
试试看
rs2.Open "abc", cn, 1,3
rstd.Open strcmdbd, cnnd, adOpenStatic, adLockOptimistic
'ADO/DAO DateObject,Extract from VBAdvisor's Project on 18/July/2007Private Sub UpdateObject()'Dim oRS As DAO.RecordsetDim oRS As ADODB.Recordset
Dim objJRO As JRO.JetEngine On Error GoTo vbErrorHandler 'Set oRS = mDB.OpenRecordset("select * from codeitems where id = " & msKey)
Set oRS = New ADODB.Recordset With oRS
.Open "select * from codeitems where id =" & msKey, mDBConnection, ADODB.adOpenKeyset, ADODB.adLockOptimistic
End With 'oRS.Edit 'DAO update Record command
oRS.Fields("code").Value = ""
'oRS.Fields("code").AppendChunk (msCode) 'DAO
oRS.Fields("code").Value = msCode
oRS.Fields("description").Value = msDescription
oRS.Fields("parentid") = msParentKey
oRS.Fields("notes").Value = ""
'oRS.Fields("notes").AppendChunk (msNotes) 'DAO
oRS.Fields("notes").Value = msNotes
oRS.Fields("example").Value = ""
'oRS.Fields("example").AppendChunk (msExample)
oRS.Fields("example").Value = msExample
oRS.Update
oRS.Close '
' Refresh the DB Engine
'
'DBEngine.Idle dbRefreshCache
' Refresh the cache to ensure that the latest data
' is available.
Set objJRO = New JRO.JetEngine
objJRO.RefreshCache mDBConnection mState = doStored
mbRead = TrueExit SubvbErrorHandler:
Err.Raise Err.Number, "PlantMachineLibary::UpdateObject", Err.DescriptionEnd Sub