LinqConnect Professional Version 4.1.169 (17-Jan-2013) - Oracle DEFAULT value

[AKRRKA]

When update database (Oracle 11g XE) from model, after change field to not null and set default value.
Get this uncorrected script:

Code: Select all

ALTER TABLE CEDATABASE."ComSchedules"
   MODIFY (
      "StartDT" TIMESTAMP,
      "FinishDT" TIMESTAMP,
      "Priority" NUMBER(3) NOT NULL DEFAULT 0
   );

Must be like this for Oracle run and don`t show error:

Code: Select all

ALTER TABLE CEDATABASE."ComSchedules"
   MODIFY (
      "StartDT" TIMESTAMP,
      "FinishDT" TIMESTAMP,
      "Priority" NUMBER(3)  DEFAULT 0 NOT NULL
   );

DEFAULT 0 before NOT NULL

[MariiaI]

Thank you for the report. We have reproduced this issue. We will inform you when it is fixed.

[MariiaI]

The issue related to wrong script generating in "Update Database From Model" wizard when setting a property as 'Nullable=false' and setting the default value has been fixed. The fix will be included in the next build of LinqConnect. We will inform you when it is available for download.

[MariiaI]

New build of LinqConnect 4.1.184 is available!
It can be downloaded from http://www.devart.com/linqconnect/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=31&t=25834.