Skip to Content
avatar image
Former Member

Pass Null Value for Time in Matrix

How to pass NULL value for Time in Matrix?

When populate data, that cell should blank if there is no Time inserted?

Field Data Type is Hours

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 04, 2008 at 09:09 AM

    hi Mahesh,

    oEdit.text=""

    regards,

    varma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 04, 2008 at 10:02 AM

    Hi..

    Try this one

    Edittext= OCol.Cells.Item(Column-ID).Specific = Nothing

    OR

    Edittext.Value = Nothing

    Regards...

    Billa 2007

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Billa,

      I used this one

      oMatrix.Columns.Item("colStpTime").Cells.Item(i).Specific.value = Nothing

      oMMDocument.UserFields.Fields.Item("U_StpTime").Value = oMatrix.Columns.Item("colStpTime").Cells.Item(i).Specific.value

      But by default 0 goes in the table so in matrix shows 12:00AM

      I required blank cell in matrix.

      If I update U_StpTime by backend as NULL then the matrix shows blank.

      But how to pass NULL by coding?