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

Eme Fibonacci

Well-Known Member

Licensed User

Longtime User

• Jan 31, 2018

• #2

SQLite?

B4X:

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

 

Upvote 0

Jeffrey Cameron

Well-Known Member

Licensed User

Longtime User

• Jan 31, 2018

• #3

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.

B4X:

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

 

Upvote 0

L

liulifeng77

Active Member

Licensed User

Longtime User

• Feb 1, 2018

• #4

thanks。

 

Upvote 0