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:
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
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 SubQUERY :
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