Yes Mike, that sounds a winner, I guess I just wanted to be ultra-lazy
and get Cayenne to manage that. I like the idea of being to mark things
as an index. Originally I was just thinking of UNIQUE CONSTRAINT or
UNIQUE INDEX (SQL Server terms) but getting Cayenne to manage all index
types would be nice, though I'm not sure how possible this is
x-database. maybe something for V2.x ;)
----- Original message -----
From: "Mike Kienenberger" <mkienen..laska.net>
To: "Steve Wells" <stwell..wnmail.net>
Date: Mon, 04 Oct 2004 17:08:45 -0400
Subject: Re: Unique fields
Steve Wells <stwell..wnmail.net> wrote:
>
> I think it would be nice to be able to flag a set of columns that would
> make each row unique (for insert), much like using natural keys. This
> is a lazy way of saying, I dont want to have to check if a set of field
> values exist in the table before I insert.
You can generally specify this in the database using indexes (at least
for
Oracle and OpenBase). Of course, since it's a lazy method, it'll just
throw
database exceptions on problems.
It might be nice to see the ability to specify indexing from the
modeler.
Andrus, if you have OpenBaseManager installed, the UI for doing that
there
is pretty cool. You just pull-down "no index", "index", "unique
index",
"clustered index", etc, for each db attribute.
Not sure how well supported this is across databases.
This archive was generated by hypermail 2.0.0 : Mon Oct 04 2004 - 21:24:52 EDT