|
|
Posted by --CELKO-- on 10/28/06 01:10
>> have a table which contains a "sortorder" column where a user can specify some arbitrary order for records to be displayed in. <<
The classic error of mixing display and data in the RDBMS?
>> Users have sometimes ordered records [sic] the way we used to number lines in a BASIC program (10, 20, 30, etc.). I'd like to do an update query and fix this so that every record [sic] is in sequential order. <<
Rows and records are totally diffreent concepts. You are still
thinking about a file system, not RDBMS. Line numbers are a physical
representation of a paper form or input screen, not a logical data
model element.
>> However, I have a slight problem! Sometimes, the users duplicated the sortorders. <<
Gee, do you suppose that might be due to the fact that they are not
relational, have no rules for validation or verifiication? And the
fact that you do not have a UNIQUE constraint on this silly column????
>> Thanks in advance for any help. <<
You might want to read book on RDBMS, data modeling and tiered
architectures
Navigation:
[Reply to this message]
|