Sorry folks, I was not as clear as I should have been (it was getting late for me).
It's a character field named "Equipment Type", tied to a Search Menu that is pulling values from a separate form "AP-Equipment Types". I'm not actually typing anything in, I'm selecting one of the values from the drop-down menu. But when I have the $MENU$ set on the pattern I get the error. I am using the same setup on some other fields, but it's been a while since I set them up so I'm sure its something stupid I've done. We are running ARS 7.0.01 on a Windows platform. MS SQL database. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, March 05, 2008 9:17 PM To: arslist@ARSLIST.ORG Subject: Re: Pattern of $MENU$ Andy, If you hare having the field patterned using $MENU$, why do you type into it or let your users type into it? Can't you just have the character field displayed as a drop-list and have the users forced to use the menus? That's an available feature in ARS version 6.3 upwards.. That would be clean and you would get what you want to do... If you are below version 6, and somewhere close to version 4.5, there used to be a bug with the $MENU$ patterning.. Even valid values would be rejected. The only fix on that version was to upgrade it. I do not recall a patch that fixed it except the next upgrade.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ]On Behalf Of Mayfield, Andy L. Sent: Wednesday, March 05, 2008 6:35 PM To: arslist@ARSLIST.ORG Subject: Pattern of $MENU$ I'm sure there is a simple answer for this, but I am encountering an error when attempting to write a value to a new character field. The error I get is "ARERR [306] Value does not fall within the limits specified for the field : (MENU - $MENU$) : Equipment Type" when trying to write to the field. On the field properties - attributes tab, I have Pattern set to $MENU$ and I have a menu that pull available values from another form created to hold the available options. The drop-down menu lists the appropriate options, but when I select one of them and try to save I get the error listed above. My understanding was that the $MENU$ option was to make sure that you selected a value from the menu, so I am confused as to what the problem might be. Thanks in advance for any help you can give. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"