Android Question Locking records in a Listview

[MarcioCC]

Good night friends, I want to do the following, I have a (for) loop that adds records in a listview, I want to lock this loop in 15 records as I do this.
Follow the code in my loop ...

       c=s.ExecQuery("SELECT CODBARRAS,QUANTIDADE FROM PRODUTOS ORDER BY CODBARRAS")
     
                  Lvadiciona.Clear
     
                   If c.RowCount >0 Then
                   For i=0 To c.RowCount-1
                   c.Position=i
                   
                                             
           
              Lvadiciona.AddTwoLinesAndBitmap(C.GetString ("CODBARRAS"), C.GetString ("QUANTIDADE"),LoadBitmap(File.DirAssets,"icone_lixeira6.jpg"))
                                 
                                       
            Next
             
           
            End If
            End If

 

[DonManfred]

There is no lock in Listview.

 

[DonManfred]

I want to lock this loop in 15 records as I do this.

You want to ONLY add 15 Records, not more?
If yes then you should use LIMIT in your Query.

c=s.ExecQuery("SELECT CODBARRAS,QUANTIDADE FROM PRODUTOS ORDER BY CODBARRAS LIMIT 0,15")

 

[MarcioCC]

Good morning, I really just want to add 15 records.
Do you have an example of how I use LIMIT?

 

[DonManfred]

Do you have an example of how I use LIMIT?

did´nt i post the updated query? It returns only 15 records!

 

[Star-Dust]

If the records obtained are less than 15 then loads all read records.
If they are more than 15 stops at record 14, which would be the 15th

c=s.ExecQuery("SELECT CODBARRAS,QUANTIDADE FROM PRODUTOS ORDER BY CODBARRAS")
Lvadiciona.Clear

If c.RowCount >0 Then
    For i=0 To Min(c.RowCount-1,14)
        c.Position=i
        Lvadiciona.AddTwoLinesAndBitmap(C.GetString ("CODBARRAS"), C.GetString ("QUANTIDADE"),LoadBitmap(File.DirAssets,"icone_lixeira6.jpg"))
    Next
End If

 

[MarcioCC]

Thanks for the help, friends, problem solved, God bless !!