Re: [Phpgroupware-developers] mssql - schema_proc

[Chris Weiss]

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