Android Question progress dialog not showing:

[manuaaa]

Hi,
While running the code progress bar is not showing.... please help

SQL1.ExecNonQuery("delete from TAB_TEAM ")
    L=  a.Query("select * from FSH WHERE  LC = "& empid &"") 'LC = " & empid & " ' changed on 18th july
    ProgressDialogShow("Wait......")
    For i = 1 To L.Size -1
        Dim MyRecord As String=L.Get(i)
        MyRecord=MyRecord.Replace("[","").Replace("]","")     'get rid of brackets in each record
        Dim strRecArray() As String
        strRecArray=Regex.Split(",",MyRecord)
        SQL1.ExecNonQuery2("INSERT INTO TAB_TEAM VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", strRecArray)
    Next

 

[DonManfred]

Are you calling it from a Activity or from a Service?

 

[jahswant]

Your code is not optimized. You should use AddNonQueryToBatch.

For i = 1 To 1000
  sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000)))
Next
Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL")
Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean)
Log("NonQuery: " & Success)

It’s more faster and your progress dialog will show up.

 

[manuaaa]

Are you calling it from a Activity or from a Service?

ACTIVITY

 

[DonManfred]

Add a

Sleep(0)

after

 ProgressDialogShow("Wait......")

 

[manuaaa]

Add a

Sleep(0)

after

 ProgressDialogShow("Wait......")

not working

 

[DonManfred]

Make sure to use resultset.

What is a?

REALLY HARD to help with this LESS info you provided.

Please upload a small project showing the problem.

 

[jahswant]

It’s more faster and your progress dialog will show up.

Did you try this ?