[ 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=10018 27&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 translate the error message: "Error in a OLE DB action that consists of multiple steps.". The error occurs when the test application tries 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=10018 27&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match