Hi Simon, 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? Thanks for your reply. Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL TECHNOLOGY 2 Contra Way Merrimack, NH 03054 603.791.5113 cell: 603.289.0481 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, March 30, 2010 9:33 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select * from tablename results in an exception On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: > I am using SQLite in a C# .NET application. I am inserting into tables > without any issues as confirmed by the SQLite Admin tool. > However, later in the application, I want to query the table where I > inserted the data, I get the following exception: > > "Failed to enable constraints. One or more rows contain values violating > non-null, unique, or foreign-key constraints." If I understand you correctly, your INSERT commands are working fine, but you get the above error when you do your SELECT. At the point where you get your error, quit your program (or allow it to quit), then use the sqlite3 command-line tool to submit the same SELECT query. See if the sqlite3 command-line too yields the same error. Make certain that the sqlite3 command-line tool is compiled using the same version of sqlite3 that your .NET framework is using. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org 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
