Empty default values in create table

[marcioqmaciel]

Hi Erik

VS Community 2015 Update 1 + SQLCEToolbox 4.4.0.4 + db CE4.0
Build Table (beta) + field with default value

SQL generated with empty default value:

-- Script Date: 13/01/2016 10:55 - ErikEJ.SqlCeScripting version 3.5.2.56
CREATE TABLE Faucet (
[Id] int IDENTITY (1,1) NOT NULL
, [Guid] uniqueidentifier DEFAULT NOT NULL
, [Nome] nvarchar(100) NOT NULL
, [Endereco] nvarchar(255) NOT NULL
, [DataCadastro] datetime DEFAULT NOT NULL
, [DataUltimaAnalise] datetime NULL
, [DataUltimoAcesso] datetime NULL
, [DataProximoAcesso] datetime DEFAULT NOT NULL
, [RecompensaMinima] smallint NULL
, [UltimaRecompensa] smallint NULL
, [Saldo] int NULL
, [EntregaRecompensa] tinyint DEFAULT NOT NULL
, [Rede] tinyint DEFAULT NOT NULL
, [Moeda] tinyint DEFAULT NOT NULL
, [IntervaloTempo] smallint NULL
, [DetectarIntervalo] bit DEFAULT NOT NULL
, [DetectarRecompensa] bit DEFAULT NOT NULL
, [DetectarSaldo] bit DEFAULT NOT NULL
, [DetectarSaque] bit DEFAULT NOT NULL
, [Avaliacao] tinyint DEFAULT NOT NULL
, [AvisarTempo] bit DEFAULT NOT NULL
, [Idioma] tinyint DEFAULT NOT NULL
, [ManterAberto] bit DEFAULT NOT NULL
, [Observacoes] ntext NOT NULL
, [PrecisaVerificar] bit DEFAULT NOT NULL
, [Problemas] nvarchar(255) NULL
, [TemFundo] bit DEFAULT NOT NULL
, [TemLogin] bit DEFAULT NOT NULL
, [TemProblemas] bit DEFAULT NOT NULL
, [TemReferido] bit DEFAULT NOT NULL
, [TesteHumano] smallint DEFAULT NOT NULL
);
GO
ALTER TABLE [Faucet] ADD CONSTRAINT [PK_Faucet] PRIMARY KEY ([Id]);
GO

My default values in Build Table: NEWID(), GETDATE() and 0 / 1.

Hugs.

[ErikEJ]

Hi, I think this is fixed in the latest "daily" build: https://sqlcetoolbox.codeplex.com/releases/view/618303

Bug: Table builder was not scripting default values

Please let me know if that fixes it for you.

[marcioqmaciel]

Hi @ErikEJ

Yes, "default value" fixed in build 4.4.0.12.

Tks a lot.

[marcioqmaciel]

Hi @ErikEJ

VS Community 2015 Update 1 + SQLCEToolbox 4.4.0.12 + db CE4.0
Edit column (Beta) + field WITHOUT default value:

ALTER TABLE [teste] ALTER COLUMN [Col] nvarchar(25) DEFAULT NULL ;

Edit column (beta) + field WITH default value is ok:
ALTER TABLE [teste] ALTER COLUMN [val] int DEFAULT 1 NOT NULL ;

Hugs

[ErikEJ]

Thanks for reporting, will be fixed in next daily/release