B4J Question How to get the the number of rows affected by the sql command

[liulifeng77]

eg:sql.ExecNonQuery("update........")or sql.ExecNonQuery("del........"

thanks a lot!

 

[Eme Fibonacci]

SQLite?

Dim changes as int =SQL1.ExecQuerySingleResult("SELECT changes();")

 

[Jeffrey Cameron]

Additionally, if you wish to find out before you execute the command, you can always use "SELECT COUNT(*)" to get a row count based on your WHERE clause, e.g.

Dim changes as int =SQL1.ExecQuerySingleResult("SELECT COUNT(*) FROM [myTable] " & myWhereClauseString)

 

[liulifeng77]

thanks。