Bugs item #1001827, was opened at 2007-02-05 15:10
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1001827&group_id=1000125
Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Error when updating a TIMESTAMP column with NULL using ADODB
Initial Comment:
We are having problems setting TIMESTAMP fields to "Null" using ADODB (from Visual Basic 6)
The attached example doesn't work, it reports an invalid date/time-value.
Setting the field to "null" with an SQL-statement works ("update ..."). It doesn't work with 08_02_0200's Unicode
version.The ANSI version works as expected.
The server is running under Linux in version 8.2.0, the clients are running under Windows XP SP2.
----------------------------------------------------------------------
>Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-23 02:56
Message:
> Instead of recordset.Update, does connection.Execute
work any better?
Maybe but please note your test program TestPgOdbc.exe
works well on my machine. I'd like to know what's happening
on your machine.
regards,
Hiroshi Inoue
----------------------------------------------------------------------
Comment By: Greg Campbell (grasshopper62)
Date: 2007-03-22 16:33
Message:
Instead of recordset.Update, does connection.Execute work any better?
e.g.
conn.Execute "UPDATE SET my_ts_field=NULL"
----------------------------------------------------------------------
Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-22 00:18
Message:
Hmm it works here.
Could you attach the Mylog output ?
regards,
Hiroshi Inoue
----------------------------------------------------------------------
Comment By: Nobody (None)
Date: 2007-03-21 09:52
Message:
I just downloaded the new drivers (2007-03-21) and repeated the test. Now I get an error "-2147217887". I'll try to
translatethe error message: "Error in a OLE DB action that consists of multiple steps.". The error occurs when the test
applicationtries to set the field value ("objRs.Fields(txtTableCol.Text) = Null").
----------------------------------------------------------------------
Comment By: Hiroshi Inoue (hinoue)
Date: 2007-02-09 07:44
Message:
PLease try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.
regards
Hiroshi Inoue
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1001827&group_id=1000125