Re: [Phpgroupware-developers] mssql - schema_proc

[Chris Weiss]

what SQL is comming out of schema_proc?  I tried the example in query
analyzer.  maybe freetds is doing something to it?



On Tue, 18 Jan 2005 23:00:47 +0100, Sigurd Nes <address@hidden> wrote:
> 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
> >
> >
> >
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
> 
>