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 03 17:20:58 CST 2024