SQL SERVER CE COLUMN INVALID ERROR

• mugahjoseph

  SSC Enthusiast

  Points: 107

  More actions

  May 17, 2010 at 12:07 pm

  #219015

  Hi all,

  I am writing a code in Visual studio 2005.

  Database is SQL server CE.

  I created a table, saved it, and used it for some times before realising that I need more columns.

  I added new columns, but when i try to insert to these new columns, it returns an error indicating that the columns are invalid.

  So, I decided to create a new table altogether with all the columns, and when I run an insert query into the table, it returns an error indicating that the table does not exist.

  I have checked the spelling of the columns and the table, and the names are alright.

  What could be the problem and how do i fix it?

  Thanks