Suppose gui-users wanted to drag and drop rows in a table so that
they could shuffle it anyway that they wanted so that the rows
maintained that order the next time they accessed the table. Can
this be done without updating alot of other rows? How is this
normally handled?
The ideas I have are
1. to use a field (possibly the primary key) and then reorder the
lower part of the table each time a row is moved.
2. to deal with it a separate table - maintain an position->key table
3. do something like have an "magical-order-field" which keeps a
string that when SORTed BY maintains the desired order. so to
insert a row between "a" and "b" set it's magical-order-field to "aab"
Got hints?
Thanks,
SEan
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------