From: | "Jonas Bruhn" <jonas(dot)bruhn(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2555: runtime error 80040e21 |
Date: | 2006-07-28 23:54:23 |
Message-ID: | 200607282354.k6SNsNGD030347@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2555
Logged by: Jonas Bruhn
Email address: jonas(dot)bruhn(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Pitt | 2006-07-29 10:33:40 | Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char |
Previous Message | Michael Fuhr | 2006-07-28 15:52:31 | Re: BUG #2553: Outer join bug |