Hi.
You should try this:
begin transaction;
declare tbl_cur cursor for select * from table order by datetime ASC;
fetch forward 10 in tbl_cur;
end transaction;
This is true if you want THE LAST 10 rows from the selection - you order it
in reverse and get the first 10. You are unable to say:
begin transaction;
declare tbl_cur cursor for .... .....
move forward all in tbl_cur;
fetch backward 10 in tbl_cur;
...........
end transaction;
because when you "move forward all" the result gets lost.
If something is unclear, do write back...
Stoyan Genov