SORRY again for my bungle , this is the real code.



CREATE PROCEDURE GET_FDET (MAX_REC INTEGER, COL INTEGER)

RETURNS (

RNO INTEGER,

EPOCH INTEGER,

MSE DECIMAL ( 18, 10 ),

TRAINTIME timestamp)

AS

DECLARE VARIABLE LINESTART INTEGER;

BEGIN

LINESTART=MAX_REC*(COL-1);

LINESTART=LINESTART+1;

SELECT FIRST (:MAX_REC) SKIP (:LINESTART) RNO, EPOCH,MSE,TRAINTIME
FROM FDET

ORDER BY RNO DESC INTO :RNO,:EPOCH,:MSE,:TRAINTIME ;

SUSPEND;

END



It's work at my ibexpert.. :-)



Regards

Agung w



[Non-text portions of this message have been removed]