rs.Open "select * from a where b = '" & c & "'", ns, adOpenStatic, adLockOptimistic
rs.Update ("d"), e
rs.Update ("d"), e
解决方案 »
- join连接double数组失败,只能连接String和Variant
- VB中VSFLEXGRID 如何用鼠标点击某一行即选中该行,并且高亮显示
- 询问VB6程序的代码框架,据说标题要长,才能引人瞩目(NGA)
- ###急死了### 一个用API设置文本框中字符串的问题!!在线等待,,解决立即给分!!
- 我为人人,人人为我.
- vb中如使用加密狗?
- SQL 问题急在线等!!!!!!!!!!!!!!!!!!!!!!!!!
- 一个读取文件长度函数(Lof)的问题
- VBA: 急急急!!为什么每次都要运行两次才能出正确结果啊??
- !!!请问哪位高手知道如何在VB里使用Panel来规划窗体,象Delephi和VB.net一样?
- 求救!谢谢各位帮忙!在文档中保存事件的问题 !?急急急!!!
- list控件的水平滚动条怎么出来?
rs("d")="ABC"
rs.Update
rs.close^_^
ns.execute "update a set d='abc' where b='" & c & "'"^_^
最好还是直接提效conn.execute "update <tablename> set <fieldname> = <value> where <condition>"
rs.update "d" , e
Or
cnn.CursorLocation=adUseClient(按默认行)rs.Update ("d") , e
在对ACCESS操作中是可行,但改为SQL server以后就不行了,能有什么法子吗?
总是提示:更新的查询失败.没发现要更新的行
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Conn.ConnectionString = "Provider=SQLOLEDB;data source=tepc-sql;initial catalog=master;user id=designer;password=t1e9p6c4"
Conn.CommandTimeout = 5
Conn.Open
Rs.Open "select * from table1", Conn, adOpenStatic, adLockOptimistic, adCmdText
Rs.Update ("a"), "aaa"
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
MsgBox "OK"
End Sub
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Conn.ConnectionString = "Provider=SQLOLEDB;data source=tepc-sql;initial catalog=master;user id=designer;password=t1e9p6c4"
Conn.CommandTimeout = 5
Conn.Open
rs.CursorLocation=adUseClient'(按默认行)加上这句后"更新的查询失败.没发现要更新的行 " 的提示才没了
Rs.Open "select * from table1", Conn, adOpenStatic, adLockOptimistic, adCmdText
Rs.Update ("a"), "aaa"
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
MsgBox "OK"
End Sub
'**************
感谢flyingZFX,问题已解决,原因见上