Android Question RDC & UPDATE

biggiu

Member
Licensed User
Hello.
I have the following problem with the RDC.
When I run an UPDATE query I have the following message in the log:

java.sql.SQLException: query does not return results

The update of the record is not performed.

Below I attach the code and the query:

B4X:
   '-----------------------------------'
    ' AGGIORNA STATO CODA               '
    '-----------------------------------'
    Sub AggStaAec
        Try
            TipLav = "AggStaAec"
            '----- Aggiorna Stato Coda
            CmdSql.Initialize
            CmdSql.Name = "UPD_TRU_AEC"
            CmdSql.Parameters = Array As Object(aecprog)
            DBRM.ExecuteQuery(CmdSql,0,TipLav)

        Catch
            Msgbox(LastException.Message,"ERRORE")
            Return False
        End Try
    End Sub
QUERY :

sql.UPD_TRU_AEC=UPDATE ANELCO SET aec_stat = 'true' WHERE aec_prog = ?


Can anyone tell me where am I wrong?

Thank you all for your cooperation
 
Top