ODBC blank date.time setting

From: Barry Bell <Barry_Bell(at)harte-hanks(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC blank date.time setting
Date: 2013-01-25 14:06:36
Message-ID: 4D51A19E0157604B94159573456A98FA25E4795E@BLUPRD0811MB413.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi:
I am accessing Postgres from a lnageuage that supports blank dates ( vardatetime={} is a valid date in foxpro).
Postgres will produce an error with we try to insert a blank date into a timestamp.
(Getting the error: )

Is there any ODBC setting that will convert the blank date (vardatetime={} ) to a null value?
(Inserting null values into a timestamp works).

This language supports "views" for updated, used by the framework of our application,

Anyone have any idea if there ODBC setting to turn to blank date to null?

Thanks
Barry Bell, IT Department

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Son Nguyen 2013-01-29 18:26:35 bug in sqlGetInfo on Linux i386 platform
Previous Message Inoue, Hiroshi 2013-01-23 23:42:58 Re: EN_Destructor bug