Re: Newbie question

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.

Paul. Received on Tue Jun 21 2005 - 18:59:04 CEST