Press "Enter" to skip to content

Refresh / Updating a form screen in Oracle D2k Forms 6i

Refresh / Updating a form screen in Oracle D2k Forms 6i

Problem

You want to show number of records processed progress or a progress bar on form through a procedure.

Solution

Declare
  nTotalRec Number := 10000;
  nCurrRec Number := 1;
Begin
   For i in 1..nTotalRec Loop
       :ablock.aitem := nCurrRec;
       Synchronize; — this will update the screen
       — do something here
       nCurrRec := nCurrRec + 1;
   End Loop;
 End;

This will do the needfull. But during this process if anybody click on the form then it will not show the progress but processing will be continued. The solution of this problem is to put the below command in when-new-form-instance trigger:

:system.message_level := 5;

Now a smooth screen update will run.

You can ask any questing related to Oracle PLSQL and D2k through comment, I will give you soon reply.



Refreshing a form in Oracle

Reviewed by Vizu Fernandis on

Jan 06

Rating:
5

One Comment

  1. Neeru Neeru February 4, 2013

    wow… thats what i want.. thanks for this post.

Comments are closed.