I have a problem joining the DELETE-UPDATE-WHERE-AND operators receiving an error as in the picture
Ho un problema unendo gli operatori UPDATE-WHERE-AND. I do not receive any errors, but the database is not updated (I also checked by extracting the .db file on the pc).
Suggestions?
Ho un problema unendo gli operatori UPDATE-WHERE-AND. I do not receive any errors, but the database is not updated (I also checked by extracting the .db file on the pc).
Suggestions?
B4X:
Dim Query As String
Query = "UPDATE Rifornimento SET Data = ?, Chilometri = ?, Importo = ?, PrezzoLitro = ?, LitriErogati = ?, Note = ?, Immagine = ? WHERE Targa = 'targaId' AND Chilometri = 'chilometriId' "
SQL1.ExecQuery2(Query, Array As String(txtDataMod.Text, txtKmMod.Text, txtImportoMod.Text,txtPrezzoMod.Text,litririf, txtNoteMod.Text,nomeimg))
Last edited: