Android Question problem with map

[3394509365]

Help in the code below I have a problem in line Cursor3.position = mapid

Using a map to derive the 'ID of a field in a table but does not seem to be MapID declared int int fact, if instead of a fixed number MapID put it all works but if I use the variable does not work. Yet in label1 see it as a number.

???

Sub SongACaso(EntryIndex2 AsInt) ' il db normaleDim Cursor3 AsCursorDim Titolo AsStringDim MapTitolo AsStringDim i,MapID AsInt'If IDList.Size = 0 Then 'check if the database is empty
' Return 'if yes leave the routine
'End If

Titolo = spnRepertorio.SelectedItem

Cursor3 = SQL1.ExecQuery("SELECT * FROM [" & TblSpin & "] WHERE [" & GestioneTbl.ColNames(2) & "] = Titolo")

For i=0To Mappa.Size-1

MapTitolo=Mappa.GetValueAt(i)
MapID=Mappa.GetKeyAt(i)
If MapTitolo=Titolo Then
Cursor3.position=MapIDExitEndIfNext

Cursor3.position=MapID

Label1.Text=MapID & "" & MapTitolo& " = " & Titolo

TxtId.Text = Cursor3.GetString(GestioneTbl.ColNames(0))
TxtProg.Text = Cursor3.GetString(GestioneTbl.ColNames(1)) 'read the FirstName columnTxtTitolo.Text = Cursor3.GetString(GestioneTbl.ColNames(2)) 'read the LasstName column
Cursor3.Close 'close the cursor, we don't it anymoreEnd Sub

 

[klaus]

This looks strange to me:

Cursor3 = SQL1.ExecQuery("SELECT * FROM [" & TblSpin & "] WHERE [" & GestioneTbl.ColNames(2) & "] = Titolo")

Shouldn't it be:

Cursor3 = SQL1.ExecQuery("SELECT * FROM [" & TblSpin & "] WHERE [" & GestioneTbl.ColNames(2) & "] = '" & Titolo & "'")

 

[3394509365]

Just perfect was wrong the query and then putting everything works perfectly cursor3.position = 0

 

[mangojack]

on a side note .. this is the first time I have seen square brackets ' [ ] ' used in a SQL statement.
is there any significant reason or just an optional use to compartmentalize a statement.

Thanks

 

[Mahares]

@mj: Whenever your table name has spaces in it, or starts with a digit, or all digits you must enclose it in brackets. Please check out this thread for my post and others for more information.
http://www.b4x.com/android/forum/threads/syntax-error-on-sql.43028/