>How about,
>
>
>SELECT X.un+1, MIN(Y.un)-1 FROM X,X Y ON X.un < Y.un GROUP BY X.un INTO CURSOR Gaps
>
>
Hi Walter, I tried it, although I had to modify your code somewhat. However, the result isn't really an endresult.
create cursor xx ( un i null )
insert into xx values ( 1 )
insert into xx values ( 3 )
insert into xx values ( 4 )
insert into xx values ( 8 )
insert into xx values ( 15 )
SELECT Xx.un+1, MIN(Y.un)-1 FROM Xx inner join Xx Y on Xx.un < Y.un GROUP BY Xx.un INTO CURSOR Gaps
browse
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
