Hi Mahesh,
The easiest solution, which doesn't require any workflow, would be to specify
the $ALPHA$ keyword as the pattern in the character field properties. This
will only allow alphabetic characters or blank spaces to be entered into the
character field, and will generate a generic error message upon submit if any
other characters are entered into the field.
Otherwise, if you prefer to use an active link or filter to generate a custom
error message, you can use a Run If qualification such as:
'myField' LIKE "%[^a-z]%"
This qualification should match any single character not within the range [a-z].
HTH,
Thomas
----- Original Message -----
From: Mahesh
Newsgroups: gmane.comp.crm.arsystem.general
To: [email protected]
Sent: Wednesday, April 23, 2008 11:13 AM
Subject: Re: Error Message on Submit if a field has special characters.
**
Sorry hit the send button quickly. I have just used a similar qualification
for validating email addresses...
((NOT ('Email' LIKE "[EMAIL PROTECTED]")) OR (NOT ('Email' LIKE "%.%")))
I guess you can use a similar qualification.
On 4/23/08, Mahesh <[EMAIL PROTECTED]> wrote:
Hello Everyone
I have a character field for inputting the name of a person. I am trying to
write an active link that will throw an error message if that field has special
characters (anything apart from A - Z). What kind of a qualification do I need
to put in RUN IF.
Environment: ARS 7, SQL Server 2005, Custom Built HD
Appreciate your time and help in advance.
Thanks
Mike
__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"
