sqlite3_changes() is exactly what you should use in this case. And I didn't understand why did you find it unsuitable for you?
Pavel On Mon, Mar 1, 2010 at 8:22 AM, yangchen <yangc...@cn.fujitsu.com> wrote: > HI, > > How could i get the rows affected by current sql statement ? > > "sqlite3_changes" can only get the rows affected by the most recently sql > statement which really affect rows. > But i don't know whether current sql statement can affect rows. > > For example: > > 1) First ,i open the database connection. > > 2) then,exeute the sql stament A : "insert into StuffTable(id,name) > values(1,'tom')" > > 3) then,exeute the sql stament B : "update StuffTable set name = 'jim' where > id = 2" > > 4) Last ,close the database connection. > > How could i konw the rows affected by stament B ? Is there any method that > can clear the rows affected. > > Thank You ! > > -- > Thanks for your attention. > --Regards-- > ----------------------------------------------------- > Yang Chen > Development Dept.III > Nanjing Fujitsu Nanda Software Tech.Co.,Ltd.(FNST) > 26/F., Civil Defense Building, No.189 Guangzhou Road, > Nanjing, China > Postcode:210029 > Phone: +86+25-86630566-617 > FUJITSU internal: 79955-617 > Fax: +86+25-83317685 > Mail: yangc...@cn.fujitsu.com > ----------------------------------------------------- > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users