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
