Page 1 of 1
MariaDB Table DateTime Column NULL Value its show "00"
Posted: Wed Jan 08, 2020 5:18 am
by shri_fwh
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.
Re: MariaDB Table DateTime Column NULL Value its show "00"
Posted: Fri Jan 10, 2020 4:31 pm
by nageswaragunupudi
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.
Re: MariaDB Table DateTime Column NULL Value its show "00"
Posted: Sat Jan 11, 2020 5:08 pm
by shri_fwh
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
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