Subject Re: [ib-support] About enforcing uniqueness with triggers
Author Helen Borrie
At 01:55 PM 03-07-02 +0200, you wrote:
>Hello everybody,
>I keep seeing a common missconception apearing, from time to time, in this
>kind of forums. It is that one could enforce uniqueness of one or more
>fields in a table with triggers instead of a unique key.

I think it bubbles up to the surface from time to time, originating from
Paradox programmers who think it's a good way to port their old client code
across to server-based processes. Later, when shades fall from their eyes
and they start to understand multi-user and transaction isolation, they
tend to discover that there actually were sound reasons why the database
designers included constraints! <g>

<Moderator hat on>
Can you please do something to avoid send those long "sig" messages? List
protocol (by international convention) says you should keep signoff text to
three lines or less.
<Moderator hat off>
<signs off with four lines of text>

All for Open and Open for All
Firebird Open SQL Database · ·