Android Question RDC & UPDATE

Discussion in 'Android Questions' started by biggiu, Mar 18, 2015.

  1. biggiu

    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:

    Code:
    '-----------------------------------'
        ' 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
     
  2. keirS

    keirS Well-Known Member Licensed User

    You should be using ExecuteCommand for an update.
     
    Erel likes this.
  3. biggiu

    biggiu Member Licensed User

    Thanks for the reply.
    Now everything works perfectly.
    good Job
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice