Default field value error Sql Server 2008
Joined: 18 Feb 2011
Topic: Default field value error Sql Server 2008
Posted: 18 Feb 2011 at 9:22am
This will fail for the value behind DEFAULT. It should be 'P'. You can add this in the editor, but why not add them automatically for string values?
CREATE TABLE [Clients] (
[id] INTEGER IDENTITY(0,1) NOT NULL,
[BeconID] INTEGER NOT NULL,
[Type] CHAR(1) NULL DEFAULT P,
[Lastname] VARCHAR(100) NULL,
Wagner R. Landgraf
Joined: 18 May 2010
|Post Options Quote Reply Posted: 18 Feb 2011 at 10:36am|
This is by design.
You can put any expression in default field, it could be constants, so you must put literal values, Data Modeler won't parse the field content just to check which parts need quotes or not.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum