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> 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 > 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 > 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 > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users