On your Search menu do you have the Label Field the same as the Value field? If not, you will get the error.
Janet Mahan Network Systems Administrator II EMBARQ Voice: 941-766-6199 | Wireless: 321-356-0128 | Fax: 941-766-6199 Email: [EMAIL PROTECTED] Voice | Data | Internet | Wireless | Entertainment This e-mail is the property of EMBARQ and may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender and delete all copies of the message. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, March 06, 2008 9:35 AM To: [email protected] Subject: Re: Pattern of $MENU$ ** 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: [email protected] 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:[EMAIL PROTECTED] Behalf Of Mayfield, Andy L. Sent: Wednesday, March 05, 2008 6:35 PM To: [email protected]<mailto:[email protected]> 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___ __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"
