The following bug has been logged online:
Bug reference: 2555
Logged by: Jonas Bruhn
Email address: jonas.bruhn@gmail.com
PostgreSQL version: 8.1.4
Operating system: Windows 2000 Pro
Description: runtime error 80040e21
Details:
I'm using VB6, and trying to update a table. It is all happening on my home
pc with IIS running too. I can download the table to a datagrid, bit I can't
type any text i a textbox and update it whith out the error occuring. Here
is the code and some remarks afterwards:
Private Sub command2_click()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Open "Provider=PostgreSQL.1;Password=***;User ID=postgres;Data
Source=localhost;Location=***" ';Extended Properties="""
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select tilbudspris, materialer from efterkalk", cn,
adOpenKeyset, adLockOptimistic
rs.AddNew
debug here --- rs("tilbudspris").Value = Text1.Text
rs("materialer").Value = Text2.Text
rs.Update
Set rs.ActiveConnection = Nothing
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
Remarks:
The columns in the table is set to text.
I've tried to write rs!tilbudspris and rs!materialer.
I've tried to trim(text1.text)
I've tried adopenstatic
I've tried rs.movefirst
I can't recognise where the problem should be, if it isn't a bug.
Best regards
Jonas Bruhn
