result->get_row_count() seems to return always 0

[jmssil]

boost::shared_ptrsqlite::result result = query.get_result();
result->get_row_count() seems to return always 0?

[vinzenz]

The problem is that the name is misleading - sqlite3_changes is used to populate this information.
However this only works for INSERT, UPDATE, and DELETE - It won't give the number of rows for a query. My bad.

I will leave this open until I find a way to provide a solution to this, anyway thanks for reporting and sorry that it took 3 years to actually answer this. I don't know why I never investigated this.

[beemibrahim]

The problem is that the name is misleading - sqlite3_changes is used to populate this information. However this only works for INSERT, UPDATE, and DELETE - It won't give the number of rows for a query. My bad.

I will leave this open until I find a way to provide a solution to this, anyway thanks for reporting and sorry that it took 3 years to actually answer this. I don't know why I never investigated this.

have you fixed it yet cuz im also getting these problems