postgresql的更新,插入问题
我在用vb6连接到远端的postgresql8.1的数据库上,对表进行插入,更新的时候报错(错误:multiple-step operation generated errors.check each status value),但是可以从表中读取数据。以下是主要的代码:
cnn.ConnectionString = "Provider=PostgreSQL OLE DB Provider;Data Source=192.168.1.166;Location=betimescontact;User ID=postgres;Password=123456;"
cnn.Open
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open " select * from t_test ", cnn, 1, 3, adCmdText
n = rst.RecordCount
Dim b As Boolean
b = rst.Supports(adAddNew)
Dim c As Boolean
c = rst.Supports(adUpdate)
rst.AddNew
rst.Fields("name").Value = "ajw"
rst.Fields("password").Value = "123"
rst.Update
在执行到“rst.Fields("name").Value = "ajw"”的时候报上面的错误,请教各位高手指点一下,不胜感激!