1. Luis Pesaressi
  2. PowerBuilder
  3. Tuesday, 27 April 2021 08:54 AM UTC

HI,

how can do for show progress bar while dw update execute (insert, update), I need show of progress the insert because to many rows import of excel and take long time

 

thanks

 

Luis

John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 27 April 2021 15:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Luis - 

I suggest you look at the SQLPreview event in the DataWindow Control. When this event contains code, it gets called prior to every SQL statement issued by the DW, so you could use it to count the number of Insert or Update statements... one for each affected row.

The first argument value (request) will tell you when an dw.Update initiated the database activity. The second argument value (sqltype) will tell you the type of SQL statement that is about to be issued.

Before initiating the dw.Update, you'll need to determine the number of rows that will be inserted or updated in order to calculate and refresh the progress percentage. You'll also want to clear your progress indicator when the dw.Update has finished.

Good luck and best regards, John

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.