MariaDB Table DateTime Column NULL Value its show "00"

Board index FiveWin for Harbour/xHarbour MariaDB Table DateTime Column NULL Value its show "00"

Posts: 336

Joined: Mon Dec 07, 2009 02:49 PM

MariaDB Table DateTime Column NULL Value its show "00"
Posted: Wed Jan 08, 2020 05:18 AM

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 24.04, BCC 7 32 bit, MariaDB

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: MariaDB Table DateTime Column NULL Value its show "00"
Posted: Fri Jan 10, 2020 04:31 PM

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: 336

Joined: Mon Dec 07, 2009 02:49 PM

Re: MariaDB Table DateTime Column NULL Value its show "00"
Posted: Sat Jan 11, 2020 05:08 PM

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 (fw): Select all Collapse

   @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 24.04, BCC 7 32 bit, MariaDB

FiveTech Support Forums

Continue the discussion