Re: Newbie question

From: Jon Heggland <>
Date: Wed, 22 Jun 2005 08:53:05 +0200
Message-ID: <>

In article <42b8475d$0$3144$>, says...
> Jon Heggland wrote:
> >>Moreover, as Joe Celko often points out, any key that is used in the UI
> >>should have check digits or similar to catch data entry errors
> >
> > 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.

It does mean you'll have to maintain consistency between the server-side and client-side checksum algorithms, though. And there is no guarantee you won't be able to enter a non-existing yet valid key (i.e. with correct check digits), is there? And doing the lookup gives the user feedback that s/he actually entered the right key, not just a wellformed  one. But if resources are *really* limited, it could be useful, I guess.

Received on Wed Jun 22 2005 - 08:53:05 CEST

Original text of this message