Re: Email Validation

Hi Niall,

Is it possible that you can tell me how i check for the error in forms?

Any help will be much appricated.

Wayne

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3e929579$0$4863$ed9e5944_at_reading.news.pipex.net...
> No it will raise an error which you can check for.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Wayne Hinch" <hinchy2000_at_lineone.net> wrote in message
> news:b6u42n$cpf$1_at_titan.btinternet.com...
> > 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 - 13:46:58 CDT