Zero in EditMask Column

Jay Schlenker

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

Hi,

I have had problems with this in the past, but have just blown it off.
Now I would like any suggestions anyone may have.

If I have an EditMask column in a datawindow with a "#" mask, is it
possible to make a 0 show up in here? As far as I know, 0 is still a
number. I have never had luck with this.

TIA
Jay Schlenker
Micro Medical Systems, Inc.

Dean Drackley

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to Jay Schlenker

Jay,

Did you try defining the edit mask as: 0###

Dean Drackley
Associate Consultant
Enterprise Information Solutions, Inc.

Jay Schlenker

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

Maybe I didn't quite phrase that properly.

If I have a column that can contain values 0 through 99, I'd define it as
##, right? I still can't see a zero. If I define it as 0##, wouldn't I see
values 000 through 099?

Thanks for the response,
Jay

Karl Moskowski

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

Try a mask of "#0". Values of 0-99 should show up correctly. The only
problem is that a NULL value would show up as 0 as well.

Jay Schlenker <jsch...@micro-medical.com> wrote in article
<34D9EC14...@micro-medical.com>...

Dean Drackley

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to Jay Schlenker

Jay,

You could define the column as an Edit Mask of 0# with spin control with
a minimum value of 0 and a maximum value of 99. When you insert a new
row, it should display a 0.

Jay Schlenker

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

That would be nice and a great way to fix my problem, but my users don't
like Spin Controls.

Jay Schlenker

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

That would take care of the problem I presented. How about this, though.

Suppose I have a 3-field combination that I will eventually convert to a date
(This is actually something I have. Why is not important) and I want 1/1/97
show up as 01 01 1997 in the 3 fields. With the edit mask, it will show up as
1 1 1997. Any ideas on this one?

Thanks for the response,
Jay

Karl Moskowski wrote:

> Try a mask of "#0". Values of 0-99 should show up correctly. The only
> problem is that a NULL value would show up as 0 as well.
>
> Jay Schlenker <jsch...@micro-medical.com> wrote in article
> <34D9EC14...@micro-medical.com>...

Karl Moskowski

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

Try "00" as the mask for the day and month fields, and "0000" for the year.
This will show leading zeroes.

Jay Schlenker <jsch...@micro-medical.com> wrote in article

<34DA0AD5...@micro-medical.com>...

Brian Carter

unread,

Feb 5, 1998, 3:00:00 AM2/5/98

to

When defining Masks remember this...

for numeric type:
0 - means there must be a number entered. If there is no number than
it will force a 0 to be shown.
# - means any number or blank space. if no number is entered than
don't show anything

so a mask of ## will show numbers 0 - 9 with a blank space at the end
a mask of 00 will show numbers from 00 - 09 with no blank spaces.

HTH

Simon Harris

unread,

Feb 6, 1998, 3:00:00 AM2/6/98

to Jay Schlenker

Also realise that even if you type a zero, PB will consider this to mean
NULL. we have this problem ALL the time!

Jay Schlenker wrote:

> Hi,
>
> I have had problems with this in the past, but have just blown it off.
> Now I would like any suggestions anyone may have.
>
> If I have an EditMask column in a datawindow with a "#" mask, is it
> possible to make a 0 show up in here? As far as I know, 0 is still a
> number. I have never had luck with this.
>
> TIA
> Jay Schlenker
> Micro Medical Systems, Inc.

--
Simon Harris
Senior Systems Engineer

Addease Pty. Ltd.
P.O. Box 1484
COLLINGWOOD VIC 3066
Australia

Ph : +61 3 9416 2944
Fax: +61 3 9416 2580
web: http://www.addease.com.au