Messages

1

General Board / Re: Column Default (SQL Server)

« on: August 27, 2007, 06:30:23 am »

Problem is EA (6.5 & 7) will produce the following SQL when a default of 0 is assigned to a column =>

create table test columna int NOT NULL default (0)

What is required (EA cannot do this) is the ability to name the default by adding a default constraint so that it can be consistanly referred to in SQL DML scripts.  By not supplying a name SQL Server allocates a system generated name at run time. This means a different SQL script has to be written for each environment that requires change.   =>

create table test columna int NOT NULL constraint DF_test_columna DEFAULT (0)

2

General Board / Re: Column Default (SQL Server)

« on: August 27, 2007, 03:50:53 am »

Ok, can you log a feature request on this or is there another protocol to follow?  I don't really give a monkeys about the SQL Server compliance level.  The absence of this functionality will be the end of your product on many sites, as it causes great difficulty with change management.  So please assign it +1000 over the earlier issue you raised.

TIA
2K5

3

General Board / Re: Column Default (SQL Server)

« on: August 27, 2007, 12:58:11 am »

Ok, my issue is with assigning column defaults a name (via a constraint), rather than the SQL Server compliance level, are we on the same page?

4

General Board / Re: Column Default (SQL Server)

« on: August 27, 2007, 12:06:20 am »

You're a man of few words!  How do I track this to discover the fix rollout?

regards,
2K5

5

General Board / Re: Column Default (SQL Server)

« on: August 26, 2007, 11:26:46 pm »

Thanks Martin,

Will you handle the admin of entering this as a priority fix?

regards,
2K5

6

General Board / Re: Column Default (SQL Server)

« on: August 24, 2007, 04:33:52 am »

Hi David,

The unique constraint is created as I would expect, (named), unfortunately this does not help my case.  We tend to use the default clause heavily to numb the pain of not nullable columns. There does not appear to be column attributes that can be set in the required way (aside of PK/Not null/unique/identity).  As EA is SQL Server 2000 compliant, rather than 2005, this may explain the absence.

I'll follow up with Sparx, they may have another angle.

many thanks
2K5

7

General Board / Column Default (SQL Server)

« on: August 24, 2007, 12:18:04 am »

As the SQL that creates a default does not specify a constraint name (create table test columna int not null default 0), the default is allocated a system assigned name at run time.  This causes problems later on when this default has to be manipulated, as a custom script is needed for each environment, due to the different system assigned default names.
Is there any way in EA to assign a column default as a named constraint (create table test columna NULL constraint DF_test_columna DEFAULT (0))?

thanks,
this is really messing up our release strategy