This project has moved. For the latest updates, please go here.
2

Closed

Error Code: 80040E14

description

edit log table:

level nvarchar 10 True False 0 0

execute code:

 -- Script Date: 5/8/2015 4:06:13 PM  - ErikEJ.SqlCeScripting version 3.5.2.49
ALTER TABLE [log] ALTER COLUMN [level] nvarchar(10) DEFAULT '11' NOT NULL ;
GO
get message:

Error Code: 80040E14
Message : There was an error parsing the query. [ Token line number = 1,Token line offset = 53,Token in error = DEFAULT ]
Minor Err.: 25501
Source : SQL Server Compact ADO.NET Data Provider
Num. Par. : 1
Num. Par. : 53
Err. Par. : DEFAULT
Closed Dec 5, 2015 at 12:15 PM by ErikEJ
Moved to github

comments

ErikEJ wrote May 10, 2015 at 4:51 AM

Thanks for reporting this - assume you are using the GUI to change the column?

Looks like this should be what was actually generated:

ALTER TABLE [Elmah] ALTER COLUMN [Host] nvarchar(50) NOT NULL;

ALTER TABLE [Elmah] ALTER COLUMN [Host] SET DEFAULT ('11');

wrote May 10, 2015 at 4:52 AM

vincentsisk wrote May 28, 2015 at 10:16 PM

I'm getting the same error, but it only occurs when I have text selected in the script editor. With no text selected, when I click 'Parse' there are no errors, but when I had 2 lines selected to copy them the following error is presented after clicking 'Parse'

Error Code: 80040E14
Message : There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = , ]
Minor Err.: 25501
Source : SQL Server Compact ADO.NET Data Provider
Num. Par. : 1
Num. Par. : 1
Err. Par. : ,

ErikEJ wrote May 29, 2015 at 10:34 AM

Please share the text in the SQL editor!

wrote Dec 5, 2015 at 12:15 PM