V4RB2 Alter Table Question

[Ruslan Zasukhin]

On 8/31/06 6:41 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> I would expect something like this
> 
> ALTER TABLE Kategorien ADD Beinflussbarkeit=3 Byte NOT NULL
> 
> or
> 
> ALTER TABLE Kategorien ADD Beinflussbarkeit Byte NOT NULL SET
> Beeinflussbarkeit=3
> 
> but in the table description  there is nothing with DEFAULT=3. Now I
> have in table description for this field the information DEFAULT=3
> something I don't want.

Claudius,

MS SQL show this error in this case:

-----------
Adding column must be nullable or have a DEFAULT definition specified for
not empty table. The column "" cannot be added to table "" because it does
not allow null values and does not specify a DEFAULT definition.
-----------


So we think that we do correct steps now.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]