[sqlite] Select * from tablename results in an exception

[Burnett, Joe]

Hi All,

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

There are no keys in the table (I removed them to try to solve this
problem), nor NOT NULL, nor foreign keys. A simple select
shouldn't worry about that, anyway. Here is my code:

                string sql = "select * from Table";
                mycommand.CommandText = sql;
                reader = mycommand.ExecuteReader();
                dt.Load(reader);
                reader.Close();

What am I missing?

Thanks in advance for your help.

Joseph Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
CELL: 603.289.0481

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users