Saving date/time field and Picker in Informix DB

General discussion forum about all databases other than SqlBase.
jurisk

Saving date/time field and Picker in Informix DB

Post by jurisk » 20 May 2013, 10:04

We are using Informix 11.50 DB with lv_lv.1257 locale. It is not possible to replace directly Date/time field with DateTime Picker (additional programming is neccessary.

If Informix DB field is with type year to fraction(5) then:

1. Date/time field can be saved in DB, DateTime Picker - cannot. It can be saved only with additional formatting as text.
2. Data from database where field is in where condiotion can be read, but with Picker cann't .

If Informix DB field is with type year to second then:

3. Date/time field and DataTime Picker cann't be saved in DB. Only can save as text
You do not have the required permissions to view the files attached to this post.

Jean-Marc Gemperle

Re: Saving date/time field and Picker in Informix DB

Post by Jean-Marc Gemperle » 10 Jul 2013, 13:40

Thanks for the testcase.
I could reproduce the issue without the use of lv_lv.1257 using en_US.CP1252 this is fortunate cause the developer version from IBM does not include this locale.

TD-19868
Date Time Picker as bind to Informix with type 'year to fraction(5)' issues
-your 2 issues...

TD-19869
TD bind variable DateTime and DatePicker to Informix with type 'year to second' error -1264

Jean-Marc

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests