Visual LANSA Forum

Is there a way to keep leading zeros?

I have a signed (9) field the represents a DUNS number, it has an edit mask of ' - - '.

The first part of some numbers is 00, which gets stripped off. For example the number 00-999-9999 is displayed as " 999-9999" instead of "00-999-9999".

I've heard about EditWord support http://vlforum.lansa.com.au/viewtopic.php?f=3&t=1161 that I thought may help, but I can't seem to find any info it, specifically how to format a value.

If you place a 0 in the tenth position of your edit word that might do it. The zero represents the last position that zero suppression is to stop so by putting it in position 10 of a 9 digit field all leading zeros should show.

Thanks Bill.

I was able to make it work by using '0**-***-****' where the * is a space.