Re: DDS screen: how to ensure field keyed is numeric for alpha-described field

Now there is a good idea!  And to really enforce data integrity 
you could add a before trigger to the file to do all of the file 
in case someone tries to backdoor around your programs.






franz400@triad.rr.com on 07/11/2000 04:34:25 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: DDS screen: how to ensure field keyed is numeric for 
alpha-described field

I know this has gone on for a while, but IMHO users hate the DDS editing
capabilities, the little blinking message, and the need to press RESET or
CTRL to continue. I like alpha fields on the screen (dare I say "pc-like"),
and I use the RPG opcode Check or Checkr and a predefined character string
to verify that no "bad" characters are entered. You build the routines 1
time, and copy them into every new pgm, or better yet, build a service pgm
or procedure to do the edit. Decent messages with no reset required, edited
in the order you control within your pgm.
Jim Franz
----- Original Message -----
From: "James W. Kilgore" <eMail@James-W-Kilgore.com>
To: <MIDRANGE-L@midrange.com>
Sent: Tuesday, July 11, 2000 3:51 PM
Subject: Re: DDS screen: how to ensure field keyed is numeric for
alpha-described field


> Joel,
>
> Try data type/keyboard shift value of 'D' - digits only.  This will work
> even though the field is defined as alpha.
>
> > "Stone, Joel" wrote:
> >
> > Our database cust# is an alpha field, but we only want to allow
> > numeric entries into the field.
> >



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---