Re: Updates and primary keys...

Malcolm Dew-Jones wrote:

> : what is the usual way to update a table including its primary keys?
>
> You're not updating the primary key in the following.

Uh, sorry. Uniqe key i meant.

> : Any other ideas how to handle this? A "only check keys on
> : commit" would be nice :)
>
> The design is wrong.
>
> o What's the point of the CustNo if it can change at any time?
>
> o adding a single customer could require you to modify every single row
> in the table. Clearly that is wrong.

Well, other suggestions are allways welcome. The task to be handle:

Store records with data into a table.
These records have a certain (business) order which can be changed by the user any time, and isn't dependant on the other columns stored. No other table depends on that table.
It has to be possible to query each record via "give me record no #n"- These Numbers have to go from 1 to max,unique, without gaps.

-- 
                                                   Andreas
if ((sex==fem)&&(hobby==comp)&&(age~25)&&(status==single)
&&(cntry=GER)) goto http://www.kochandreas.com/home/single.htm