On 02/03/2019 16:24, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 02/03/2019 16:06, Lester caineles...@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 ...
Except it's only half the solution :( I was hoping to avoid traversing the parent gallery ... it would be nice to just return a single record with the target content id. -- 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