Обсуждение: ODBC Blank Date convert to null

Does anyone know of an setting in the ODBC driver that will convert a blank date to a null?


Thanks
Barry 

Hi Barry,

(2013/05/17 5:07), Barry Bell wrote:
>
> Does anyone know of an setting in the ODBC driver that will convert a blank date to a null?

Are you using Unicode driver?
Could you send me the Mylog output of the case?

regards,
Hiroshi Inoue

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
executingthe 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