I have written sql code to create a SQL Server CE database to be deployed on a Windows Mobile emulator using the SqlCeEngine object. The sql statements are enclosed in the form load procedure. However, when i run the program i get the following error: There was an error parsing the query [ Token line number = 1,Token line offset = 14,Token in error = User ] which references the sqlcreateTable.ExecuteNonQuery() method.
I have looked up the meaning of this SqlCeException on MSDN but no help there. Can any one explain what i may be doing wrong? Below is a snippet of code that produces the error:
sqlCreateTable.CommandText = "CREATE TABLE User(userID int PRIMARY KEY, " + "username nvarchar, password nvarchar)"; [B]sqlCreateTable.ExecuteNonQuery();[/B] // produces an SqlCeException error message