Re: Email Validation

Wayne Hinch wrote:

> 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
> >

What Niall said.

In general ... all validation should be on the server rather than in the form. Doing this has several advantages.

1. Easier coding and maintenance.
2. No circumvention via connection through other tools.
3. Leaner forms meaning faster load time.
4. Leaner forms meaning less network traffic.

Daniel Morgan Received on Tue Apr 08 2003 - 10:47:20 CDT