Re: Email Validation

Wayne Hinch wrote:

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

Are you familiar with the form level on-error trigger?

Just pop up an alert when-ever the returned error matches specific criteria.

Daniel Morgan Received on Tue Apr 08 2003 - 15:03:16 CDT