Updated Model from Database Keeps say NULL has changed
Posted: Fri 30 Aug 2013 10:06
Every time I update the model from the database I get a lot of columns being marked as changed when they have not been modified at all. The message is the same:
This message for example was shown for the UnicodeDecimal column of the following table:
CREATE TABLE Currency (
Code char(3) PRIMARY KEY NOT NULL,
Name nvarchar(100) NOT NULL,
ShortName nvarchar(100),
UnicodeDecimal nvarchar(20) DEFAULT NULL,
UserDefined boolean NOT NULL DEFAULT 0
);
CREATE INDEX CurrencyIdx_NameCode
ON Currency
(Name, Code, UserDefined);
dotConnect for SQLite Version: 4.6.301.0
Server Version: 3.7.17
PRAGMA synchronous=NORMAL
PRAGMA journal_mode=WAL
Code: Select all
DefaultValue(old="NULL", new='NULL') was changed.
CREATE TABLE Currency (
Code char(3) PRIMARY KEY NOT NULL,
Name nvarchar(100) NOT NULL,
ShortName nvarchar(100),
UnicodeDecimal nvarchar(20) DEFAULT NULL,
UserDefined boolean NOT NULL DEFAULT 0
);
CREATE INDEX CurrencyIdx_NameCode
ON Currency
(Name, Code, UserDefined);
dotConnect for SQLite Version: 4.6.301.0
Server Version: 3.7.17
PRAGMA synchronous=NORMAL
PRAGMA journal_mode=WAL