Android Question Progressbar with SQLite NonQuery

[Kiran Raotole]

Hi Experts,

This is SQlite Update Code

    Dim count,limit,offset As Int
    count = db.ExecQuerySingleResult($"select count(*) from a"$)
    limit = 100
    offset = 0
    Do While offset < count
        db.ExecNonQuery( _
            $"UPDATE a SET amt= (update sum values here)
                WHERE condition and
                      ROWID IN (SELECT ROWID FROM a WHERE LIMIT ${offset},${limit})"$)
           
        Log("LIMIT : " & limit & "    OFFSET : " & offset & "  Time : " & DateTime.Time(DateTime.Now))
        show_progressbar_new(offset / count * 100)
        offset = offset + limit
    Loop

show_progressbar_new

    Log("show_progressbar_new : " & progress)
    pnlProgress.Visible = True
    B4XProgressBar1.Progress = progress

show_progressbar_new is running but not showing Progress status of B4XProgressBar1.Progress
If I put sleep(0) in loop then progressbar progress start showing but function completed instantly without finish whole loop

What should I do....?

 

[Erel]

Use async methods.
[B4X] SQL with Wait For