Re: Email Validation

Daniel,

If i alter this table in this way how can i program it on the client side (forms)? Because if i don't do anything on the client side it will only crash won't it?

Wayne

"DA Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3E91A211.9695AB12_at_exxesolutions.com...
> Wayne Hinch wrote:
>
> > Hi,
> >
> > I am trying to validate an email which a user will enter, how do I go
about
> > to do this? I would like to trap for an @ and a . in the text field on a
> > form which is being programmed in Forms 6.0.
> >
> > Any help will be much appreciated.
> >
> > Wayne
>
> Use a check constraint on the underlying table.
>
> ALTER TABLE person
> ADD CONSTRAINT cc_person_email_address
> CHECK (per_email_address LIKE '_%@_%._%');
>
> Data constraints belong in the table, not the form.
>
> Daniel Morgan
>
Received on Tue Apr 08 2003 - 04:17:11 CDT