Re: Newbie question
Date: Wed, 22 Jun 2005 08:53:05 +0200
In article <42b8475d$0$3144$ed2619ec_at_ptn-nntp-reader01.plus.net>,
> 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.
-- JonReceived on Wed Jun 22 2005 - 08:53:05 CEST