-----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-----

Reply via email to