Thorsten Kersting <thorsten.kerst...@itp1.uni-stuttgart.de> wrote: > i have one database, with three tables. My programm (c++) tries to > create the tables every time it writes into them, but that shouldnt do > any harm. > the problem is now, that i find data from one table written into another > table.
With all due respect, I find it difficult to believe. If you execute a statement like INSERT INTO TableX VALUES(...); this statement may succeed and insert a row into TableX, or it may fail and not insert any rows. Under no circumstances can it insert a row into some other table, say TableY. Perhaps you are building the statement on the fly, choosing the table name dynamically. Or perhaps you are renaming tables with ALTER TABLE statement, after some rows have already been inserted. Either way, look for problems in your code. If you still have difficulty, post here a reasonably small self-contained sample that reproduces the issue. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
