[gnome-db] IMPACTED_ROWS
Piotr Pokora <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
Hi! gda_connection_statement_execute_non_select returns correct number of affected rows (UPDATE prepared statement) when I use SQLite provider. With MySQL one, there's 0 returned, even if at least one row has been affected. I use libgda 4.2, but I suspect the same issue is valid for 4.0. Can I work around it somehow? I can do: SELECT x WHERE y=z; if (x) UPDATE if (!x) INSERT But this seems to be much better. affected_rows = UPDATE if (affected_rows == 0) INSERT Piotras