× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Doesn't look like the BLANKS keyword solves the issue. The user wants to enter a 0 and then have that 0 be displayed the next time she pulls up the record. Or for it to still be blank if she hasn't keyed in any 'value' yet.

Looks like the BLANKS keyword would only work the first time around.

What I am thinking now is that I'll just make the default value of the field a negative 1. The I can condition the display field to show a reverse image blank if the value is -1. It'll be updated when the user enters a 0 or otherwise.

Thanks

Bob Cagle
IT Manager
Lynk

-----Original Message-----
From: Charles Wilt

All you're really doing with a Y/N flag is rolling your own NULL bit...

Take a look at the BLANKS keyword for DDS DSPF fields...
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzakc/rzakcmstdfblank.htm

Charles

On Wed, Feb 22, 2017 at 9:12 AM, Bob Cagle <bcagle@xxxxxxxxxxx> wrote:

Further background on this: The user asked for a new field to be added
to our item info screen for tracking vendor commissions, so I added a
2 digit numeric field to the file and the screen.

Then when the user went to enter the commissions, she entered all the
commissions that should be 0 first. Yes, she went through several
records and entered zero into a field that she saw as blank. She
expected then to see that 0 to be displayed, but of course it wasn't
since I have it zero-suppressed. I explained to her how that works
and that she wasn't really changing the value and offered to remove
the zero suppress from the field. But when I told her that would
display 0 in every field that was 'blank', she said that wasn't going
to work either. Her question was 'How am I to know which items I haven't entered the commission for yet?'

So, yes, the user wants to distinguish between zero and blanks in the
field. I thought maybe a null value would work, but sounds like I
just need to convert it to character. I also briefly considered a
secondary field - a Y/N flag saying the commission had been entered.

Thanks

Bob Cagle
IT Manager
Lynk

-----Original Message-----
From: MichaelQuigley@xxxxxxxxxx

Can you define the situations that could have a null? All I can
think of is a new record? Or perhaps a numeric field for date
terminated sort

of thing? In any event, it seems to me that knowing how that null
field

will be used might pretty well define how you handle it?

I do like the idea of a a mark, perhaps underline a null? It still
confuses me though. How will the user key a blank/null into a
numeric field?


I'm not clear, but I think the OP is not really looking for genuine
null fields. It sounds like they just want to distinguish between
actually having blanks or zeroes in the field. If so, edit codes should work.

If they're really after distinguishing true null values, I like how
DBU does it. They condition the field to use column separators (and
yellow) when the value is null.

Michael Quigley


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.