April 17th, 2004, 03:19 PM
Swap Sort Order
Hi, I am looking for some help on an application that I am developing.
What I am trying to accomplish is to change the sortorder column from 1 to 9 and then have all the other sort records update themselves. IE. 1 becomes 9, 2 becomes 1, 3 becomes 2,....., 9 becomes 10, 10 becomes 11, etc...
Any help would be appreciated!!!!!
April 17th, 2004, 08:24 PM
very sketchy description, not sure i understand
might have helped if you could say what it's for
when sortfield=1 then 9
when sortfield<9 then sortfield-1
when sortfield>8 then sortfield+1