Re: Unique fields

From: Mike Kienenberger (
Date: Mon Oct 04 2004 - 17:08:45 EDT

  • Next message: Mike Kienenberger: "Re: SQL Template & Thread Safety"

    Steve Wells <> 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 - 17:07:47 EDT