SQL Server Compact Edition 3.5

[bob]

Hi,

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

A third party Database console has no problems running the queries

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

Appreciate any thoughts on the above.

Thanks
Bob