Hi, Igor, On Tue, Apr 23, 2013 at 8:55 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 4/23/2013 11:47 PM, Igor Korot wrote: > >> During the program flow I need to insert a record in one of the tables >> inside transaction. >> Record inserts OK (no error message generated), but when I try to check >> using the SQLite >> console the record is not present. >> I let the transaction finish and check using the console program - record >> is still not present. >> > > What exactly does "let the transaction finish" mean? Do you issue a COMMIT > or END statement? What you describe looks very much like the program > terminates leaving an uncommitted transaction behind, which is then rolled > back. > In the beginning I'm issuing "BEGIN". In the end if everything is good I'm issuing "COMMIT", if not "ROLLBACK". So when running under debugger in Visual Studio, right after sqlite3_step() call I am issuing SELECT * FROM playersdrafted in the console. It comes back empty. Upon restarting the program and going thru the same algorithm, I let it run after "COMMIT" and then query the table. It still comes back empty. Hopefully it explains it. Thank you. -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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
