phpgroupware-developers
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Phpgroupware-developers] mssql - schema_proc


From: Sigurd Nes
Subject: Re: [Phpgroupware-developers] mssql - schema_proc
Date: Tue, 18 Jan 2005 23:00:47 +0100
User-agent: Mozilla Thunderbird 1.0 (Windows/20041206)

It doesn't work like that for me (when created through the phpgwapi) - is there some magic I need to do on the server?

Sigurd


Chris Weiss wrote:
create table testnulls ( f1 int )

then look at it in enterprise manager, f1 gets the NULL attrib by
default.  If you want it to disallow nulls you do have to say NOT NULL
explicitly.


On Mon, 17 Jan 2005 20:47:42 +0100, Sigurd Nes <address@hidden> wrote:

That's sounds very strange to me – I have 7 – and I am certainly not
allowed to insert a row containing NULL where not expected.
What would it hurt to explicitly state that fields can take NULL ?

Sigurd

Chris Weiss wrote:

is this new for mssql2k?  it's not the case this in 7.


On Mon, 17 Jan 2005 10:49:02 +0100, sigurdne <address@hidden> wrote:


In order to be able to install on mssql – the columns that can take NULL has
to be explicitly told to:

Can some one please add this to class.schema_proc.inc.php on line 448 (HEAD v
1.10):

else
{
$sFieldSQL .= ' NULL';
}

This is posted as bug #3818  05/30/2003 (different line)  – but still valid.

Sigurd

_______________________________________________
Phpgroupware-developers mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers





_______________________________________________
Phpgroupware-developers mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers




_______________________________________________
Phpgroupware-developers mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers





_______________________________________________
Phpgroupware-developers mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers








reply via email to

[Prev in Thread] Current Thread [Next in Thread]