MariaDB Table DateTime Column NULL Value its show "00"

Post Reply
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

MariaDB Table DateTime Column NULL Value its show "00"

Post 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.
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: MariaDB Table DateTime Column NULL Value its show "00"

Post 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.
Regards

G. N. Rao.
Hyderabad, India
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: MariaDB Table DateTime Column NULL Value its show "00"

Post 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

 
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
Post Reply