Hi,
Oops, accidentally posted this to the C# group so apologies for cross
posting.

VS2008 IDE Desktop app.

Anybody out there deploying this db?

I am finding a strange problem with column names.

I am using an SQLCeCommand to create a datareader.
I have a where clause that is refusing some of the column names.
Saying the column name is not valid.
The columns are visible in Server explorer.

It seems to be column names that where added later on in the tables
design.
example of problem
"select * from unit where parent_id = 1"  //fails, parent_id was added
after initial table construction

"select * from unit where id = 1"  //works id was part of table
initial construction

A third party Database console has no problem running the queries

Code:

SqlCeConnection conn = new SqlCeConnection(mstrConnectionString);
//mstrConnection just has  "DataSource = myFullPath\mydatabase.sdf

               conn.Open();
               string sql = "select * from unit where parent_id = 1";
               SqlCeCommand cmd = new SqlCeCommand(sql,conn);
               SqlCeDataReader r = cmd.ExecuteReader();  //DROPS DEAD
HERE with 'invalid column'

Appreciate any thoughts on the above.

Thanks
Bob