Handling zOrder Rankings on columns

From: shinkell <steve.hinkell_at_eresourcesinc.com>
Date: 14 Jun 2001 12:33:06 -0700
Message-ID: <3866171d.0106141133.42b4223a@posting.google.com>

We have table defined as ...

incidents

---

incidentid, number
rank, number

now most of you can guess my question based on the rank column, but here it goes ...

i need to do a type of zorder on the rank column on updates to that column - example:

incidentid rank

-------------------  ------
312312321            1
42534252435          2
3423423423           3
253454234423         4

update incidents set rank = 2 where rank = 4

Q: Without having accessiblity to the code to do the update, i will probably need to use a trigger to handle the reordering. Does anybody have any ideas.

• Steve H.

Received on Thu Jun 14 2001 - 14:33:06 CDT