Android Question failure dbutils.executemap

angel said:

Hello

I am running dbutils.executemap to read BD data and gives me error

B4X:

QueryPM = "SELECT * FROM " & DBTableName & " WHERE ID = 3"
    Dim QueryPMMap As Map
    QueryPMMap.Initialize
    QueryPMMap = DBUtils.ExecuteMap(SQL1, QueryPM, Null)
    If QueryPMMap = Null Then
        lblspSelectPrimer.Text = "N/A"
    Else
        lblspSelectPrimer.Text = QueryPMMap.Get("primerMedicament")
    End If

Thanks

Click to expand...

Viewed this way, there are no errors.

Are you sure of the names of the fields?

Post the error log.

Hello

If the fields in the database are correct, attached one image with the error in the module.

Dim DBFileName As String : DBFileName = "DosisFiebreDB.db"
Dim DBFileDir As String : DBFileDir = File.DirDefaultExternal
Dim DBTableName As String : DBTableName = "taula_temporitzador"

Thank you.

Hello

Works "primerMedicament" field in the database included a space "primerMedicament "

Thank you.