-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi Dennis, | | It won't because the temp tables created by your program ar private to its | database connection. They are not visible through the database connection | opened by sqlite.exe. You can verify this by running two copies of | sqlite.exe in seperate command prompt windows (both looking at the same db | file). You can create permanent tables in one and they will be displayed in | the other, but temp tables will only be displayed by the program that | created them. Aha! That's the other thing I was wondering about... I added a logger to watch which queries were going through and discovered that the TEMPORARY TABLE was being created and also was sticking around. Turns out that I had the wrong column name, and so it was segfaulting. Thanks so much for your help! I really appriciate it :).
- -- Taj -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBvdq0qFV3Jf1Ui+IRApvqAJ0e3aUXryQzf0busuNcs9VzUNjvCgCgvQLz pKDWM6CL3LSOk8SCYZy8+xc= =ZsMg -----END PGP SIGNATURE-----