DDS: Entering value in numeric field

5 pts.
Tags:
Application development
AS/400
RPG
RPGLE
Is there any way (field attribute, key word, etc.) to keep the beloved end user from not using the field exit key when entering a value in a numeric field? We have users who will continually use the tab key or just hit enter when entering a 1 (for example) in a field, thereby creating a value of 100 million, 1 billion, etc. My associate and I have searched for a solution, but with no luck. Thanks, Bill
ASKED: June 30, 2006  11:38 AM
UPDATED: June 21, 2013  5:38 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

we had this problem and we implemented a very nice solution, but our solution requires very much work on your part.

We removed all numeric fields from screens and replaced with character fields. We then have a service program that validates, parses and re-formats the character field into a nice, viewable field.

The result is very, very nice. Very user friendly. And, resolves the problem that you stated. It also resolves the problem where users want to enter a currency symbol or commas into the number. There is more overhead, but such a solution works very, very well.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DaddyCOZ
    we had this problem and we implemented a very nice solution, but our solution requires very much work on your part. We removed all numeric fields from screens and replaced with character fields. We then have a service program that validates, parses and re-formats the character field into a nice, viewable field. The result is very, very nice. Very user friendly. And, resolves the problem that you stated. It also resolves the problem where users want to enter a currency symbol or commas into the number. There is more overhead, but such a solution works very, very well.
    0 pointsBadges:
    report
  • CarterC19
    There is a field-level DDS keyword that may help: CHGINPDFT(FE) Requires the user to press a Field Exit key to leave the field.
    220 pointsBadges:
    report
  • AJordan
    You could also use the field attribute CHECK(RZ). These will right adjust the field and replace with leading zeros regardless of how the field is exited. If the user types a 1 in a 5 byte numeric field, instead of it being interpreted as 10000 it is interpreted as 00001.
    0 pointsBadges:
    report
  • JDWWms
    Quick answer is use the Mnadatory Field Exit (MF)keyword. Requires them to always use the field exit key even when entering data. If you're using Client access you want to remap the keyboard so they can get to field exit without using the shift key. Unless Field Exit + - are good enough.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following