Von: Prajeesh Prakash [mailto:prajeeshprakash@elear.solutions] Gesendet: Mittwoch, 05. Dezember 2018 13:47 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>; Hick Gunter <h...@scigames.at> Betreff: Re: [sqlite] [EXTERNAL] Number of changes
Thank you i tried sqlite3_changes() but in that case i INSERT 2 rows but it gave 1. On December 5, 2018 at 5:51 PM Hick Gunter <h...@scigames.at<mailto:h...@scigames.at>> wrote: RTM. Sqlite3_total_changes() counts the *total* number of changes done since the connection was opened. To get the number of changes made by the *last statement*, use sqlite3_changes(). This applies only to connections that are not shared between threads. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Prajeesh Prakash Gesendet: Mittwoch, 05. Dezember 2018 13:10 An: sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] [sqlite] Number of changes Hi team, How we can find the number of changes done on a particular table in DB using sqlite3 library function (C program). I tried with sqlite3_total_changes() but its doesn't helps me. I am writing only one record but its giving me 22 records. At present my db contains 23 table and i tried to INSERT record into 1 table out of 23 after INSERT (i used sqlite3_exec()) i kept sqlite3_total_changes() but it giving result as 22. Thank you _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH<http://www.scigames.at> | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users