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