update progress bar during execution of entitycopy command

Author: szhu@commandalkon.com (szhucommandalkon)

we use entitycopy to archive customer database (as an application module). The table size varies from table to table and from customer to customer. The biggest table we are going to do is 150 GB in size. The whole database copy process takes 40 hours. That 150 GB table accounts for half of the time. Users sometimes may want to kill the application simply because the progress bar does not move and they thought the app is dead. It would be of great help if Uniface has separete work thread to update the progressbar during execution of entitycopy.

4 Comments

  1. have you tried a "SHOW" comman after you have modified the progressbar? This should make the changes visible.


    Author: ulrich-merkel (ulrichmerkel@web.de)
  2. Hi, I don't think show is the problem. You have to program some loop into your process. Within this loop (e.g. copy only 1000 entries) you have to call the frontend part to refresh (maybe with a show) the screen and then go ahead within you service. If you use one single statement (copyentity) there will no change to visualize the process, because there will be no interrupt. Best regards Thomas


    Author: Thomas.Young (thomas.young@young-consulting.de)
  3. I would put an outputbox below the progressbar The entitycopy statement has a printinterval option that gives a message after each x records. Redirect that to the outputbox and the user can see if there still is progress.


    Author: Theo Neeskens (tneeskens@itblockz.nl)
  4. Hi Theo, thanks for mentioning the output box in connection with the printinterval. A brilliant example what the output box is good for (and can not be done otherwise)


    Author: ulrich-merkel (ulrichmerkel@web.de)