Re: Newbie question

In article <11bgseiseqng1ce_at_corp.supernews.com>, misha_at_no_mishapen_spam.co.uk says...
> Paul wrote:
> > Jon Heggland wrote:
> >>Why is that? Just to avoid a lookup on the key value?
> > I guess it's a practical consideration so that simple typos can be
> > trapped by the client, to save hitting the database server. In some
> > scenarios this could be useful.
>
> Primarily it is required to prevent simple typos (or misread
> handwriting, or misheard phone calls) from picking up another (but wrong
> ) entity.

I don't see how that is possible. If a key value picks up a wrong entity, then the value must obviously be valid according to the checksum algorithm, so it won't help at all.

-- 
Jon