Subject Re: [ib-support] Is there any UNIQUE limit?
Author Matteo Giacomazzi
Hi Helen,

Wednesday, July 03, 2002, you wrote:

HB> I wasn't suggesting you should post less.. :-))

Oh, okay, sorry, just misunderstood! :)

HB> However, if the row has an atomic integer primary key you should
HB> use this for the FK relationship, since it is shorter and is
HB> simplex. Complex foreign keys are are PITA.

Okay, that's what I thought too!

HB> Look for UPPER().

Thank you!
Interbase manuals are _really_ _big_!!! :)

HB> Place BeforeInsert and BeforeUpdate triggers on these
HB> columns that do
HB> ...
HB> if (new.MyColumn is not null) then
HB> new.MyColumn = UPPER(new.MyColumn);
HB> ...

I would make something different because no user is granted to insert
in those tables: they have to use SP that performs some other checks
and that returns the corresponding ID (a new one or an old one if the
entry already exists).

Thank you for the suggestions!

Kind regards,

ICQ# 24075529