请帮我看看这段代码 可能 是rs.Open strsel, , adOpenDynamic, adLockBatchOptimistic, 1出现了错误,“cnn"这个参数还是要的吧! 你可以试着用database和recordset 对象呀! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 adLockBatchOptimistic好像要用updatebatch吧要不就不要用开放式批锁定了吧adLockOptimistic cnn不能用默认的参数,必须改光标类型等等我记不太清了。 还是用"insert into"得了,我觉得还规范点!!1 '既然向identify记录中插入新值,为什么用identify字段来筛选记录集呢,又不是更改字段内容。dim strSql as stringSet cnn = New ADODB.Connectionset db as new adodb.database cnn.ConnectionString "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\project\vb\lzzl\lzzl.mdb;Persist Security Info=False" cnn.OpenstrSql="insert into resume (identify,bianhao,startdate,enddate,bureau,position,wittness)values(1,6,'" & cdate(txtsdate.text) & "','" & cdate(txtedate.text) & "','" & txtbureau.text & "','" & txtpos.text & "','" & txtwit.text & "';"cnn.execute strsql Thanks to all我先将插入代码修改如下,调试通过If curstate = "add" Then empid = frmmain.subAdodc.Recordset.Fields(0) curbianhao = frmmain.subAdodc.Recordset.RecordCount + 1 d1 = CDate(txtsdate.Text) d2 = CDate(txtedate.Text) strsel = "INSERT INTO resume VALUES(" & empid & "," & curbianhao & ",'" & d1 & "','" & d2 & "','" & txtbureau.Text & "','" & txtpos.Text & "','" & txtwit.Text & "')" cnn.Execute strsel On Error GoTo InsertError MsgBox "记录已添加", vbOKOnly Else d1 = CDate(txtsdate.Text) d2 = CDate(txtedate.Text) curbianhao = frmmain.subAdodc.Recordset.Fields("bianhao") strsel = "UPDATE resume set startdate='" & d1 & "',enddate='" & d2 & "',bureau='" & txtbureau.Text & "',position='" & txtpos.Text & "',wittness='" & txtwit.Text & "'" strsel = strsel + "where (bianhao=" & curbianhao & ")" cnn.Execute strsel On Error GoTo ModifyErr MsgBox "记录已被修改", vbOKOnly End If但是有碰到新的问题,用UPDATE 修改记录时,语句的语法不正确,可是我看MSDN和书上都是这么写的呀。 不是空格问题如果只对一个字段修改就不会出错,如改成 strsel = "UPDATE resume set startdate='" & d1 & "'" strsel=strsel+" where ...."就能更新的。 如何用VB改变ACCESS中表的列宽 Winsock1_DataArrival后怎么判断数据是否是指定IP,Port传过来的呢?抢分了~~~~~~~~~~~~~~~~~~~~~~ ProgressBar被StatusBar挡住了,怎么办? 请教VB6日文版的下载网址 VB中读取数据库数据并按一定格式打印,有多少种方法? 招聘志同道合的同仁 借宝地 谢谢 一个小小问题,希望各位高手作答(在线等待) 关于VB WMI获取硬盘信息的不解之处 如何在VB中调用用C编写的API函数 怎样取得一张图片中某一个位置的颜色值??( 控件属性~~~ 如何后台打印报表
要不就不要用开放式批锁定了吧
adLockOptimistic
Set cnn = New ADODB.Connection
set db as new adodb.database cnn.ConnectionString "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\project\vb\lzzl\lzzl.mdb;Persist Security Info=False"
cnn.OpenstrSql="insert into resume (identify,bianhao,startdate,enddate,bureau,position,wittness)values(1,6,'" & cdate(txtsdate.text) & "','" & cdate(txtedate.text) & "','" & txtbureau.text & "','" & txtpos.text & "','" & txtwit.text & "';"cnn.execute strsql
我先将插入代码修改如下,调试通过
If curstate = "add" Then
empid = frmmain.subAdodc.Recordset.Fields(0)
curbianhao = frmmain.subAdodc.Recordset.RecordCount + 1
d1 = CDate(txtsdate.Text)
d2 = CDate(txtedate.Text)
strsel = "INSERT INTO resume VALUES(" & empid & "," & curbianhao & ",'" & d1 & "','" & d2 & "','" & txtbureau.Text & "','" & txtpos.Text & "','" & txtwit.Text & "')"
cnn.Execute strsel
On Error GoTo InsertError
MsgBox "记录已添加", vbOKOnly
Else
d1 = CDate(txtsdate.Text)
d2 = CDate(txtedate.Text)
curbianhao = frmmain.subAdodc.Recordset.Fields("bianhao")
strsel = "UPDATE resume set startdate='" & d1 & "',enddate='" & d2 & "',bureau='" & txtbureau.Text & "',position='" & txtpos.Text & "',wittness='" & txtwit.Text & "'"
strsel = strsel + "where (bianhao=" & curbianhao & ")"
cnn.Execute strsel
On Error GoTo ModifyErr
MsgBox "记录已被修改", vbOKOnly
End If但是有碰到新的问题,用UPDATE 修改记录时,语句的语法不正确,可是我看MSDN和书上都是这么写的呀。
如果只对一个字段修改就不会出错,如改成
strsel = "UPDATE resume set startdate='" & d1 & "'"
strsel=strsel+" where ...."
就能更新的。