On 8/31/06 4:54 PM, "Ivan Smahin" <ivan_smahin (AT) valentina-db D.OT com> wrote:
>> 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?
Aha.
Ivan, other dbs like MSSQL, Sybase do the same thing ?
May be it needs improve error message ?
E.g.
you cannot add new NOT NULL column without DEFAULT value
into that table have records
?
--
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]
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Ruslan Zasukhin |
