• Subject: DDS screen: how to ensure field keyed is numeric for alpha-described field
  • From: "Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx>
  • Date: Tue, 11 Jul 2000 12:23:05 -0400

Title: DDS screen: how to ensure field keyed is numeric for alpha-described 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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.