Home » Developer & Programmer » Forms » Open window in loop (oracle forms 10g, webutil)
Open window in loop [message #392386] Tue, 17 March 2009 13:55 Go to next message
ator
Messages: 38
Registered: March 2009
Member
hi,
My problem is this.
In a loop i read a file and, when i find a string X i have to open a window where insert some data.
the problem is that the loop won't pause but will keep go on.

My question is: There is a way to pause the loop as long as the modal window still open? Or it is not possible and i have to do in a different way?

Thx for help Smile

ps: sorry for my english :s
Re: Open window in loop [message #392402 is a reply to message #392386] Tue, 17 March 2009 16:09 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does it mean that you want to exit the loop? If so, you'll need to ... well, EXIT. Here's an example:
SQL> BEGIN
  2    dbms_output.put_line('Before the loop');
  3    FOR cur_r IN (SELECT deptno, dname FROM DEPT
  4                  ORDER BY deptno
  5                 )
  6    LOOP
  7      IF cur_r.deptno <> 30 THEN
  8         dbms_output.put_line(cur_r.dname);
  9      ELSE
 10         dbms_output.put_line('Deptno 30 reached - exiting the loop');
 11         EXIT;
 12      END IF;
 13    END LOOP;
 14    dbms_output.put_line('The end');
 15  END;
 16     /
Before the loop
ACCOUNTING
RESEARCH
Deptno 30 reached - exiting the loop
The end

PL/SQL procedure successfully completed.

SQL>
If you'd, on the other hand, like to exit the procedure, substitute EXIT with RETURN.
Re: Open window in loop [message #392408 is a reply to message #392386] Tue, 17 March 2009 16:38 Go to previous messageGo to next message
ator
Messages: 38
Registered: March 2009
Member
No, i want to stay in the loop and this is the problem. I tried to find a solution all over the web but i didn't find 1.
Example:

loop
....
open window and pause loop
when window close unpause loop
....
end loop;

i start to think that it is not possible do it in pl/sql Sad.
if u can help will be awesome otherwise i find another way for my problem Razz

Thx anyway Smile
Re: Open window in loop [message #394713 is a reply to message #392408] Sun, 29 March 2009 19:56 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Open window in loop [message #394906 is a reply to message #392386] Mon, 30 March 2009 15:05 Go to previous message
ator
Messages: 38
Registered: March 2009
Member
No, i found out is not possible so i just avoided the problem with a insert and afterwards i open a window to modify the data.
Previous Topic: How get incorrect login attempts during the last login
Next Topic: How to get Application server IP address
Goto Forum:
  


Current Time: Fri Dec 09 07:53:00 CST 2016

Total time taken to generate the page: 0.26878 seconds