Re: Unique value
From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/29
Message-ID: <5rlb0m$2ef_at_panix.com>#1/1
Date: 1997/07/29
Message-ID: <5rlb0m$2ef_at_panix.com>#1/1
> I am developing an application using Developer/2000
> in which I want the user name to be unique.
> For example in my application there cannot another user with
> the same first name and last name.
>
create unique index {whatever} on {table_name}.{column_name}
tablespace {some_tablespace)
storage (initial ???k next ???k);
This will prevent duplicate without any code.
-- ------------------------------------ If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at http://www.panix.com/~gsa/index.htmlReceived on Tue Jul 29 1997 - 00:00:00 CEST