Android Question How to use 'Wait for' when loading data in a spinner

[demonio_jack]

Hi everyone!!!
I'm loading data from a database and I don't know how to show a progressbar during the process. Just want to show a progress circle to show users that data is loading...

this is teh code:
'********************************************

Sub CargarDatosJ
    Try
        pgbBarra.Visible=True
       
        Starter.Connect
        Dim cur As JdbcResultSet= Starter.mysql.ExecQuery("select concat(idcategoria,' - ',nombre) categoria from categorias1 where activa=1 order by nombre")
        Do While cur.NextRow
            spnCategorias.add(cur.GetString("categoria"))
        Loop
        spnCategorias.SelectedIndex=6
        cur.Close
        Dim niv As JdbcResultSet = Starter.mysql.ExecQuery("select concat(idnivel,' - ',descripcion) nivel from niveles")
        Do While niv.NextRow
            spnNiveles.add(niv.GetString("nivel"))
        Loop
        spnNiveles.SelectedIndex=1
        niv.Close
    Catch
        Log(LastException)
    End Try
    Starter.CloseConnection
    pgbBarra.Visible=False
End Sub

'********************************************
Any idea???

Thanks. ;-)

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

 

[Erel]

Any idea???

Yes. You are making synchronous remote queries. This is a big mistake.

I assume that you are using JdbcSQL. Switch to the async methods.
[B4X] SQL with Wait For

 

[Peter Simpson]

Hey @demonio_jack

1. First you need to know how many records you are going to return
2. In your Do While make sure to have a counter i + i + 1 etc
3. Use following code to map the record counter range to the progress bar value, you will need Sleep(0)

✅ MapRange Mapping A-B to C-D

SubName: Map a range of numbers from A-B to C-D and return the mapped value. Description: I use B4R a lot and that package includes a function called MapRange. B4A doesn't have a version of MapRange and I couldn't find one on the forum anywhere, so I found the formula online and I put together...

www.b4x.com

How many records are you returning???

 

[Erel]

The problem is in the query itself. You must use async methods with remote databases.

 

[demonio_jack]

The problem is in the query itself. You must use async methods with remote databases.

Thanks Erel!!! I'll try the new solution with async methods. ;-)

 

[demonio_jack]

Hey @demonio_jack

1. First you need to know how many records you are going to return
2. In your Do While make sure to have a counter i + i + 1 etc
3. Use following code to map the record counter range to the progress bar value, you will need Sleep(0)

✅ MapRange Mapping A-B to C-D

SubName: Map a range of numbers from A-B to C-D and return the mapped value. Description: I use B4R a lot and that package includes a function called MapRange. B4A doesn't have a version of MapRange and I couldn't find one on the forum anywhere, so I found the formula online and I put together...

www.b4x.com

How many records are you returning???

not over 100 rows..