Re: Go_Block() inside of a Loop.. Why doenst this simple code work? Please take a look........

Mark S Reichman wrote:
>
> The following code is on a KEY-COMMIT in SQL FORMS 3.0. The entire
> form has two blocks('one','two'). Now, all I want to do is show a pop up
> inside of a loop each and every time it loops. So, I wrote the following
> code. This code intends to show the pop up block when the count is equal
> to 5. Funny thing though, the loop completes and I get the "You are at the
> end..." message and then the block appears. Why? Why does the form
> complete the entire loop then show the block? It should(?) loop to 5,
> show the block, continue to loop to 10, then show the "You are at the end..."
> message. But, it doesn't...
>
> This is ofcourse a simplified version of a more complicated code but if I
> can get this to work then I can get my other code to function also..
>
> This is one instance of why I prefer C... Please Help...
>
> declare
> cnt number(5) := 0;
>
> begin
> while cnt <= 10 loop
> cnt := cnt + 1;
> if cnt = 5 then
> go_block('two');
> end if;
> end loop;
> end;
> message('You are at the end...');
> bell;
> commit;

Use the SYNCRONIZE command to see the pop-up block before the entire PL/SQL block is executed.

-Sridhar Nallani

CARDS group,
The Boeing Company. Received on Wed Jun 25 1997 - 00:00:00 CEST