Why are you calling reset after step? regards, Adam
On Fri, Feb 6, 2009 at 3:51 PM, Stephen Abbamonte <st...@tornadostudios.com> wrote: > Hi all I am using SQLite3 and running into a bit of a snag. I have a > Database with an empty table and I am calling a series of INSERT commands > during the execution of my program but it seems that each call is > overwriting the first row in the table. I have tried the table with and > without a PRIMARY KEY and I get the same result. The call to sqlite3_step > with my INSERT command returns SQLITE_DONE so I call sqlite3_reset first > then I call sqlite3_finalize. Then I prepare a new statement and > do these steps again. If anyone can help I would greatly appreciate it. > Thanks. > > > > Stephen Abbamonte > > Software Engineer > > Tornado Studios > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users