Unique value

[Vijaya L. Natarajan]

Hi,
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.

I can do this by giving a IF Statement in the WHEN-VALIDATE-RECORD
trigger to check whether there exists a user with the same first
name and last name before inserting a new record.

But I don't know how to do this during update.
Is there any idea to accomplish this , please let me know
my email address is vija...@cs.uga.edu

[Gary Assa]

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