Error message setup
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to test the inputted data for the following conditions, and then display an error message with the record # of the error. The first column called Ref1 is numeric data formatted as text due to necessary leading zeroes.
error if data in Ref1 column is not numeric characters
error if data in Ref1 column is 00000
error if the 7th character in a field is anything other than a dash
error if the length of a column is other than 11 characters
I have used the Message command previously to display errors for positive tests (e.g. x=0, name = 'George', etc.) But the exclamation-point errors out instead of negating the positive statement.when I use it in the error message tool.
What am I missing here?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ppatane The first condition and the third condition contradict each other. The first error says error out if it is non-numeric and the third says check for the 7th char which is not '-', then error out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs My apologies for my poor communication
The first 2 rows refer to one field, the last 2 rows refer to other fields
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ppatane One way of doing this
