On 02/03/2019 16:24, Lester Caine lester@... [firebird-support]
wrote:

> On 02/03/2019 16:06, Lester Cainelester@... [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