为什么数据不能更新????急...在线等
我用下面这段代码对imageId为4000的记录进行更新,可是总更新不了,
提示, Current Recordset does not support updating.This may be a limitatiion of the provider,or of the selected locktype.
我把rs.lockType的四个属性都试了一次,也没有成功的.这是为什么??
mstream.Open
mstream.LoadFromFile "e:\13.jpg"
'ÏÈ°Ñimageid=4000µÄ¼Ç¼ÕÒ³öÀ´
Set rs = con.Execute("select * from tb1 where imageID=4000")
rs.update
rs!question = "这是为什么?"
rs!imageID = 4000
rs!Picture = mstream.Read
rs.UpdateBatch
mstream.Close