Re: Beginner Validation

From: Mabel Trigüis <mabelle_at_bluewin.ch>
Date: 1998/02/17
Message-ID: <01bd3c18$5ffa4200$970bbac3@m3bj1>#1/1

Hi Richard:
ALTER TABLE mytable
ADD CONSTRAINT mytable_uk
UNIQUE (snum);
Please check with your manuals or online help. Regards
Mabel

Richard Fairbairn <r.fairbairn_at_zetnet.co.uk> wrote in article <1998021716040976740_at_zetnet.co.uk>...
> Can someone help me with this problem?
>
> I have a table which has a primary key 4 digit column (snum). Each
> value in this column must be unique.
>
> In Forms 4.5 I'm trying to write a procedure to check that a new snum
> is unique (I.e., has not already been used.)
>
> Can anyone give me some ideas?
>
> I'm very new to this.
>
> Best regards
>
> R.W. Fairbairn
>
>
Received on Tue Feb 17 1998 - 00:00:00 CST