Nico Callewaert schrieb:

>
> Thanks Lucas,
>
> But the problem is, the next ItemNo is not always CurrItemNo + 1....

Yes, I know and what?

Have a look at the sql again:

SELECT xxxxxxx FROM xxxxxxx
WHERE ItemNo > :qItemNo
ORDER BY ItemNo

If you have records like:
ItemNo.
--------
100
104
108
109
255
256

when your current record is 100 and you want to get the next one it will
be 104, then 108, then 109 and so on.

So where's the problem?

Luc.