Hello Claudius,
Wednesday, August 30, 2006, 9:32:31 PM, you wrote:
> 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 D.OT 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
Yes, I see.
The source of "problem" is filled table.
You can not add not-nullable field or field without default value to
filled table.
Simple reason - what values do you expect to see in that field for
existing records?
--
Best regards,
Ivan mailto:ivan_smahin@valentina-db.com
_______________________________________________
Valentina mailing list
Valentina At lists D.OT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Ivan Smahin |
