Book a Demo

Author Topic: Incorrect "null" valeur when generating ddl  (Read 2432 times)

tomDoPoetou

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Incorrect "null" valeur when generating ddl
« on: August 13, 2018, 08:21:09 pm »
Hello,

Our company is using Entreprise Archive 12.0.1215.

When trying to generate the ddl to sqlServer 2012, in the table creation script some (but not all) of the attributes defined as belonging to the PK are incorrectly defined as 'NULL'.

Example:
CREATE TABLE [TYPE]
(
   [ID_TYPE] int NULL,    -- Identifiant du type
   [CODE_TYPE] varchar(4) NOT NULL,    -- Code de type
   ...
)
GO

When trying to regenerate, problem occurs always on the same attributes of the same tables.
Cant figure in which case it happens, I tried to uncheck/recheck PK with no success.

Did anyone face the same problem, and find a solution ?

Thanks in advance,
Thomas

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: Incorrect "null" valeur when generating ddl
« Reply #1 on: August 14, 2018, 06:54:32 am »
Don't have that problem.
Have you ticked the PK and Not Null checkboxes for the attribute?
Happy to help
:)