Home » Developer & Programmer » Forms » fetching records
fetching records [message #193742] Tue, 19 September 2006 04:05 Go to next message
webadministrator
Messages: 45
Registered: October 2005
Member
hello,

if we want to jump 50 records each time when we click next,of total records of 10000 from database is it possible to be done?

thank u.
Re: fetching records [message #193767 is a reply to message #193742] Tue, 19 September 2006 06:05 Go to previous message
jowahl
Messages: 82
Registered: May 2006
Member
define a trigger:

BEGIN
    FOR i IN 1..50
    LOOP
        IF :SYSTEM.LAST_RECORD = 'TRUE' THEN
           EXIT;
        END IF;
        --
        NEXT_RECORD;
        --
    END LOOP;
END;
Previous Topic: exporting & importing
Next Topic: Form query
Goto Forum:
  


Current Time: Tue Dec 06 10:09:34 CST 2016

Total time taken to generate the page: 0.22217 seconds