Dear Rao Sir ,
A MariaDB Table has DATETIME column and in the table there are null values for the column but in FiveWin Application its showing "00:00:000.000".
Please guide me for the same.
MariaDB Table DateTime Column NULL Value its show "00"
MariaDB Table DateTime Column NULL Value its show "00"
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
- nageswaragunupudi
- Posts: 8017
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Contact:
Re: MariaDB Table DateTime Column NULL Value its show "00"
Yes, that is how we programmed.
NULL values are displayed as empty values of the corresponding data type.
This is makes it very easy to prepare Gets.
NULL values are displayed as empty values of the corresponding data type.
This is makes it very easy to prepare Gets.
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Re: MariaDB Table DateTime Column NULL Value its show "00"
Dear Rao Sir ,
Thanks a lot ...!
So I will make it "NIL" before displaying on the screen. The application displaying the values of creation / update date time as given below
Thanks a lot ...!
So I will make it "NIL" before displaying on the screen. The application displaying the values of creation / update date time as given below
Code: Select all
@260, 020 SAY "Cr." SIZE 040, C_SAYH PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
@280, 020 SAY "Upd." SIZE 040, C_SAYH PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
@260, 100 SAY aVTxnS1[ IDX_TXNVOU_S1_CR_BY ] SIZE 100, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
@260, 210 SAY aVTxnS1[ IDX_TXNVOU_S1_CR_DT ] SIZE 200, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
@280, 100 SAY aVTxnS1[ IDX_TXNVOU_S1_UPD_BY ] SIZE 100, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
@280, 210 SAY aVTxnS1[ IDX_TXNVOU_S1_UPD_DT ] SIZE 200, C_SAYSMALL_H2 PIXEL COLOR C_SAYFCLR, C_SAYBCLR FONT oApp:oFontSmall2 TRANSPARENT
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB