sort data in non-base table multi record block [message #86918] |
Fri, 19 November 2004 21:11 |
odeveloper
Messages: 34 Registered: September 2004
|
Member |
|
|
hi
i am using forms6i and 10g for development of user interface. i have a problem that i have multi records block which is non-base table. i want to sort data in this block for user to check when user complete data entry and press button OK to finish. can i do it???
thanks.
|
|
|
Re: sort data in non-base table multi record block [message #86928 is a reply to message #86918] |
Sun, 21 November 2004 19:50 |
hay
Messages: 6 Registered: August 2003
|
Junior Member |
|
|
GO_BLOCK(NON BASED BLOCK NAME);
FIRST_RECORD;
LOOP
--Using any Sorting Algortmes
--NON_BASED BLOCK like ARRAY
--The RECORD like NODE in ARRAY
--You can moving by NEXT_RECORD and PREVIOUS_RECODR
NEXT_RECORD;
EXIT WHEN :SYSTEM.LAST_RECORD ='TRUE';
END LOOP;
|
|
|
|