V4RB2 Alter Table Question

[Claudius Sailer]

Hi Ruslan,

Am 30.08.2006 um 20:10 schrieb Ruslan Zasukhin:

> On 8/30/06 7:04 PM, "Claudius Sailer" <Claudius at sailer-online.de>  
> wrote:
>
>> Hi,
>>
>> 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
>> UPDATE Kategorien SET Beeinflussbarkeit=3
>>
>> is this no longer supported?
>> How can I delete after Alter Table the setup DEFAULT 3?
>> Or is this something which is now allways there?
>
> Ivan say that he cannot reproduce. For him works
>      ALTER TABLE Kategorien ADD Beinflussbarkeit Byte NOT NULL
>
> So I assume secret is in your db.
>
> Please try open db in viSQL or in Vstudio, and try this ALTER command.
> If reproduce, then please send us your db.
>
> Also I think good idea add this issue into Mantis

#1772
everything is attached.
Screenshot from viSQL and database for testing

bye


Claudius

-- 
iMac CD 2GHz / MacOS X 10.4de / RB 2006r3/ Valentina 2.4.1
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]