B4J Question jRDC2 know affected rows

[fhersof]

Greetings, Please if you can guide me a little, I am implementing jRDC2 and from an Android mobile I want to know the number of rows affected when sending an update query to the server, thank you very much.

 

[Erel]

The actual details depend on the db engine you are using.

If you are using MySQL for example then you can do something like:

'jRDC2 server RDCHandler
con.BeginTransaction
        Dim Total As Int
        For Each cmd As DBCommand In commands
            con.ExecNonQuery2(Main.rdcConnector1.GetCommand(cmd.Name), _
                cmd.Parameters)
            Total = Total + con.ExecQuerySingleResult("SELECT row_count()")
        Next
        res.Rows.Add(Array As Object(0))
         res.Columns.Put("AffectedRows", Total)
        con.TransactionSuccessful

 

[fhersof]

The actual details depend on the db engine you are using.

If you are using MySQL for example then you can do something like:

'jRDC2 server RDCHandler
con.BeginTransaction
        Dim Total As Int
        For Each cmd As DBCommand In commands
            con.ExecNonQuery2(Main.rdcConnector1.GetCommand(cmd.Name), _
                cmd.Parameters)
            Total = Total + con.ExecQuerySingleResult("SELECT row_count()")
        Next
        res.Rows.Add(Array As Object(0))
         res.Columns.Put("AffectedRows", Total)
        con.TransactionSuccessful

It is precisely what I needed and it works perfectly, thank you very much Erel