Data Type - Pattern match - Range Check (AREV Specific)
At 23 FEB 2001 08:12:29PM M Ford wrote:
I am using AREV 3.12.
I defined a field with a DATA type of DECIMAL(4,2) and wish to validate that data entered is in the range of 00.00 to 99.99.
I defined a data field in a window (using Quick Paint). The Data Type for the field is defined as DECIMAL(4,2) and input validation pattern is (MD2)+(00.00,99.99)
With this definition the system will accept data in the range of .00 - .99.
I tried many other combinations of data types(interger Decimal) and Input validations patterns but was unable to find a combination that would validate the data correctly for the range (00.00,99.99).
I anticipate I have missed something quite basic.
Help will be appreciated.
At 24 FEB 2001 01:14AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Check you have set both the dictionary attributes (shift-F10 from paint) and the screen prompt attributes (shift-F6 from paint)
Here's a rough example:-
World Leaders in all things RevSoft
At 26 FEB 2001 11:39AM Warren wrote:
Show-offs!
At 26 FEB 2001 11:48AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
pretentious? moi?
World Leaders in all things RevSoft
At 26 FEB 2001 02:27PM M Ford wrote:
Thanks for your help. I changed the order of the validation by placing the range check ahead of the validation (MD2. The validation now works correctly. Thanks also for the Shift F10 reminder.
Mark