|
View previous topic :: View next topic
|
| Author |
Message |
Mickeydusaor
Active User
Joined: 24 May 2006
Posts: 258
Location: Salem, Oregon
|
|
|
|
My question is what if you have a negative value in a field (-).??
then you are making it a postive value (+).
I would check all the fields in the table for a valid SIGN and display
the RECORD KEY of any fields that were in ERROR in a REPORT so
that someone could look at the record and determine if the value
should be a (+) or a (-) value.
simple test.
SPECIAL-NAMES.
CLASS VALID-PACVALS IS '0' THRU '9', '-', '+'.
if DATABASE-field VALID-PACVALS
bypass this record
else
move record-key to report
end-if |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
The sorry thing is, from what I can tell, is that he is causing the error by his move to an edit field and back. The "junk" he finds is his own doing...  |
|
| Back to top |
|
|
Mickeydusaor
Active User
Joined: 24 May 2006
Posts: 258
Location: Salem, Oregon
|
|
|
|
Yes if there are moving the +ZZZ to the database field they are
causing there own problem. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
One more time. . . .
If we can see the actual content of the bad field(s), we will surely be able to offer recommendations.
There may be nothing wrong (but i suspect there is) or as Bill suggests - whatever is wrong is self-inflicted.
And surely flipping the sign from a '+' to a '-' would be a very bad thing to do. . . |
|
| Back to top |
|
|
|
|
