Re: Email Validation

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 Mon Apr 07 2003 - 11:06:41 CDT