I need to randomly get some rows from a cursor. FETCH ABSOLUTE would be the key to avoid more complicated ways. But, it seems only works with constant offsets!

DECLARE PREMIO_ INTEGER;
...
SET PREMIO_ = RAND(_PREMIOS)+1;
FETCH ABSOLUTE PREMIO_ FROM CURSOR_ ('ID') INTO TARJETA_;

ElevateDB Error #700 An error was found in the statement at line 31 and column 25 (Expected constant value expression but instead found "PREMIO_")

Will be possible using any integer value?

Thanks!

Tiago,

<< I need to randomly get some rows from a cursor. FETCH ABSOLUTE would be
the key to avoid more complicated ways. But, it seems only works with
constant offsets! >>

Sure, I can add that in the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Sure, I can add that in the next build.>>
Thanks, Tim. I guess you also'll do this for RELATIVE clause

--
Tim Young
Elevate Software
www.elevatesoft.com