Android Question Select all markers maps sql

[Croïd]

I use a SQL database with maps to display markers. I would make them invisible markers with the zoom.
if I only have one record in my file .db, this works well.
But if I have multiple record line, the function does not work !
do I have to initialize again sql?

For i = 0 To sqlcursor.RowCount -1
sqlcursor.Position = i
'PinsId = sqlcursor.Getint("Id") ' ID
PinsTxt = sqlcursor.GetString("Site") ' Name
PinsLat = sqlcursor.GetDouble("Latitude") ' Lat
PinsLng = sqlcursor.GetDouble("Longitude")  'Lng
m1 = gmap.AddMarker3(PinsLat,PinsLng,PinsTxt,bmp.Bitmap)
Next
sqlcursor.Close

and

Sub MapFragment1_CameraChange (Position As CameraPosition)
If gmap.CameraPosition.Zoom > 12 Then
'ToastMessageShow("+ 12",False)
m1.Visible = False
Else
m1.Visible = True   
End If       
End Sub

 

[Erel]

Your code assigns all markers to the same variable. The variable will point to the last marker added.

You need to use a Map or List and add all the markers to the data collection.

 

[Croïd]

Can you tell me the problem with attachment ?

Just :

Dim ListMarkers As List
ListMarkers.Add(m1)

 

[Erel]

You are initializing the list inside the loop. This means that you are clearing it each iteration.

 

[Croïd]

Thank you very much Erel, now it works well , I a little confused