Can you modify the data entry program and make the field a numeric field
instead of a text field? Then only numbers will be accepted...or validate
that only numbers exist in the text field, if a character is in there then
throw and error and make them rekey it... if you don't have access to the
data entry program how are you supposed to know what to do with the dashes
and pluses? You can remove them but the data is still wrong because you
have no idea what the user intended. Garbage in garbage out.
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
J M Plank <plank.computer@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/24/2010 10:37 AM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
To
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
cc
Subject
Re: Dashes in the middle of a number being ignored
It's a manager miskeying a number. She meant to key 506 and keyed 5-6
instead (from the numbers at the top of the keyboard). She wants it fixed
to prevent this. I also discovered a plus sign in the middle of the
number
is ignored (i.e. 34+7 is seen as 347).
Normally the wedge will be used, so this would be a non-issue. This is
for
a sister company we are bringing onto our system, so they will likely only
be hand-keying in the weights to enter all their product into the initial
inventory. They have bales of feathers in the 500-1100 pound range and
don't want to pull all of them onto the scale to create the tickets the
"normal" way. These bales do have the weight hand-written on them so
don't
need reweighed at this time. This process creates a label with a bar code
that is used in further processing and/or shipping.
Thanks.
Mark Plank
On Wed, Mar 24, 2010 at 10:24 AM, DeLong, Eric
<EDeLong@xxxxxxxxxxxxxxx>wrote:
Mark,
What kind of numeric value is 5-6? Is that supposed to be a fraction?
Perhaps it's supposed to be lbs-ozs to represent a weight?
midrange.com
