Thread: [ psqlodbc-Bugs-1001827 ] Error when updating a TIMESTAMP column with NULL using ADODB
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: 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