Re: ODBC Blank Date convert to null

Hi Barry,

Thanks.
Isn't qo_deliver timestamp type?
If so, there's no such version that converts blank timestamp to null.

I've built a trial version.
Could you please try the dll on testing for 9.1.0300 at
http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/index.html
setting the Extra Opts = 0x8?

regards,
Hiroshi Inoue

(2013/05/17 22:08), Barry Bell wrote:
> Error is (when putting a blank date into field qo_deliver
> "ERROR: invalid input syntax for type timestamp: "";\ aError while executing the query"
>
> vfp9 30e8-2f90 ENTER SQLExecDirect
> HSTMT 0x0036C4D8
> UCHAR * 0x0258E488 [ -3] "UPDATE HITS.DLPOINTS SET QO_DELIVER=? WHERE QO_ID=?\ 0"
> SDWORD -3
>
> vfp9 30e8-2f90 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
> HSTMT 0x0036C4D8
> UCHAR * 0x0258E488 [ -3] "UPDATE HITS.DLPOINTS SET QO_DELIVER=? WHERE QO_ID=?\ 0"
> SDWORD -3
>
> DIAG [22007] ERROR: invalid input syntax for type timestamp: "";
> Error while executing the query (7)
>
> vfp9 30e8-2f90 ENTER SQLErrorW
> HENV 0x02298E28
> HDBC 0x0036C1F8
> HSTMT 0x0036C4D8
> WCHAR * 0x0018E130
> SDWORD * 0x0018E178
> WCHAR * 0x0018DD30
> SWORD 512
> SWORD * 0x0018E17C
>
> vfp9 30e8-2f90 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
> HENV 0x02298E28
> HDBC 0x0036C1F8
> HSTMT 0x0036C4D8
> WCHAR * 0x0018E130 [ 5] "22007"
> SDWORD * 0x0018E178 (7)
> WCHAR * 0x0018DD30 [ 83] "ERROR: invalid input syntax for type timestamp: "";\ aError while executing the query"
> SWORD 512
> SWORD * 0x0018E17C (83)
>
> vfp9 30e8-2f90 ENTER SQLErrorW
> HENV 0x02298E28
> HDBC 0x0036C1F8
> HSTMT 0x0036C4D8
> WCHAR * 0x0018E130
> SDWORD * 0x0018E178
> WCHAR * 0x0018DD30
> SWORD 512
> SWORD * 0x0018E17C