B4J Question jSQL - How to get affectedRows from ResultSet?

[Mashiane]

Ola

For inserts, update, delete, how can I get the affectedRows?

Thank you.

 

[Harris]

Refer to the ABM DBM module for clues.


For example:
I needed to know the Master PKey of an Insert to associate all following detail records - before adding them...

Sub ABMGenSQLInsert(SQL As SQL, Query As String, Args As List) As Int
    Dim res As Int
    Try
            
        SQL.ExecNonQuery2(Query,  Args)
            
        If UsePool Then
            res = SQLSelectSingleResult(SQL, "SELECT LAST_INSERT_ID()")
        Else   
            res = SQLSelectSingleResult(SQL, "SELECT last_insert_rowid()")
        End If       
    Catch
        Log("SQL Insert: "&LastException.Message)
        res = -99999999
        
    End Try
    Return res
End Sub

This module is GOLD! Once I figured out what it was doing...

 

[Mashiane]

Thanks @Harris , well from the look of things. For inserts, updates and deletes, there seems to be no way of getting affectedRecords as yet.

I guess I will have to implement a similar approach on the DBM but using parameter queries instead, Erel warned on his "code smells" about db queries.

Ta!

 

[b4x-de]

See: https://www.sqlite.org/lang_corefunc.html#changes

SELECT changes();

i.e.

AffectedRowCount = mDb.ExecQuerySingleResult("SELECT changes();")