On 02/03/2019 16:06, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > In the past ( 20 years ago;) ) I would simply have added a second > position column which is consecutive numbers and reordered them when > changes are made, but I'm wondering if with all the things that have > been added since then has provided an SQL means of returning the before > and after value directly from the current data?
OK another reason for moving over to FB3 ... LEAD and LAG working nicely ... -- Lester Caine - G8HFL ----------------------------- Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.co.uk