V4RB2 Alter Table Question

[Ruslan Zasukhin]

On 8/30/06 7:04 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

Hi Claudius, 
 
> I want to alter a table and I do it this way because all other tries
> fails because of NOT NULL
> 
> ALTER TABLE Kategorien ADD Beinflussbarkeit Byte DEFAULT 3 NOT NULL
> 
> I really would do
> 
> ALTER TABLE Kategorien ADD Beinflussbarkeit Byte NOT NULL
^^^^^^^^^^^^^^^^^^

This produce error, right ?

> UPDATE Kategorien SET Beeinflussbarkeit=3
 
> is this no longer supported?

This must work.

Yes we have note this anomaly in description to your other bug report.
Ivan was going try reproduce this today. Don't know results yet.

> How can I delete after Alter Table the setup DEFAULT 3?

Via PAI way I think:

    tbl.fld.DefaultValue = nil

> Or is this something which is now allways there?

-- 
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]