RE: DDS screen: how to ensure field keyed is numeric for alpha-descri bed field

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

You can change the field in SDA to have a keyboard shift attribute of 'D'
for digits only.  It is under Keying Options under Field Keywords.  This
results in a data type of D which is a character field if no decimal
positions specified.

A            FLD001         6D  B  3 44  

Scott Mildenberger

> -----Original Message-----
> From: Stone, Joel [SMTP:StoneJ@GourmetAward.com]
> Sent: Tuesday, July 11, 2000 10:23 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      DDS screen: how to ensure field keyed is numeric for
> alpha-descri bed field
> 
> Our database cust# is an alpha field, but we only want to allow numeric
> entries into the field. 
> 
> What is a good way to ensure data keyed into a field is numeric using DDS
> screens? 
> 
> I can't chain to the cust file in some cases because ranges are allowed,
> for example two fields exist on the screen to key a start cust# and an end
> cust#.
> 
> Also, I dont want to allow an entry such as "0   0   0" (problem, spaces
> in between). 
> 
> What is the simplest way to accomplish this? 
> 
> TIA 
> 
+---
| 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
+---