On 30 Mar 2010, at 2:55pm, Burnett, Joe wrote: > Your understanding is correct. However, I used the SQLite Admin tool and > the select * query > was successful after the table was populated and the program exited. > > Isn't that the same thing?
Okay, if I understand your result, you have a specific SELECT query, and this query executes correctly in the sqlite3 command-line tool, but it fails when you execute it in your application, which uses a .NET framework. Instead of that specific SELECT, can you try one on a different table ? If that works, try one on that table which doesn't use all the columns. If it fails, try one of the PRAGMA commands that returns a table as an answer (e.g. "PRAGMA compile_options;"). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
