Re: Updates and primary keys...

Andreas Koch (mail_at_kochandreas.com) wrote:

: 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:

I hope to make a few suggestion when I get some more time.

: 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

--
Want to access the command line of your CGI account?  Need to debug your
installed CGI scripts?  Transfer and edit files right from your browser? 

What you need is "ispy.cgi" - visit http://nisoftware.com/ispy.cgi