Windows grid hide a date field with value 1900-01-01

[atostaine]

I have a date(10) field defined as a column in my grid. What's the best way to hide the value of 1900-01-01?

I've been fooling with grid.currentitem.cell but haven't had any success.

Thanks, art

[Jurgen.Rentinck]

Hi Art,

Try to set the value to *SQLNULL before you add the entry to the list.

Code: Select all

* this should result in an empty cell
#datex := *SQLNULL
Add_Entry To_List(#Grid1)
* this should result in an cell containing 01-01-1900
#datex := *NULL
Add_Entry To_List(#Grid1)

[atostaine]

Thanks I don’t think that was working for me. Let me try again.

[atostaine]

Thanks I don’t think that was working for me. Let me try again.

[atostaine]

Our field was imported from IBM i and SQLNull wasn't an allowed output attribute. LANSA won't let me add an attribute to an imported field. I made a new field and all works good.

Thanks