Android Question Progressbar while using SQL statement example

[mscientist33]

Is there an example of using a progressbar while looping through a resultset of an SQL statement. I have progressbars in other places in my app and they work fine but if I use it while looping through a resultset the progress never gets updated.

 

[klaus]

Without seeing what you have done it is impossible to give a concrete advice.
You need to give more information.
Do you really need a ProgressBar to loop through a resultsetof an SQL statement.
Is it really that long, what are you doing in this loop ?

 

[ilan]

Is there an example of using a progressbar while looping through a resultset of an SQL statement. I have progressbars in other places in my app and they work fine but if I use it while looping through a resultset the progress never gets updated.

are you using ExecQueryAsync?
i guess the reason for that is the sql process is freezing your app. use ExecQueryAsync and update every query your progress bar. it may be that you will need to use Sleep(0) function to refresh the progress bar and redraw it but try first without Sleep(0) but use ExecQueryAsync.

 

[mscientist33]

Thanks @ilan , the ExecQueryAsync was the ticket. I was using begin.transaction and using ExecNonQuery2.