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
