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 - 04:25:12 CDT
