hi!
(i'm new in APEX and I don't speak much english, I will use google traductor)
I'm making a mobile application in which according to 2 input data, shows a reflow report of 10 rows. But I want the "siguiente" button performs the action of displaying the following 10 rows.
attached images for better understanding:
the query the report is as follows:
select seq_ntvn_cdg, mtin_cdg, mtin_dsc, dnvn_cnt, ntvn_total
from vtfc.det\_nota\_venta
where :P4\_CLIENTE=empr\_cdg
and :P4\_VENDEDOR=vndr\_cdg
order by seq\_ntvn\_cdg DESC
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
thank you very much in advance!!!