----- Original Message -----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Wednesday, November 03, 1999 6:34 PM
Subject: Re: [Emerald] Creating New Service
> Todd Coward wrote:
> >
> > We're having a problem creating a new service in Emerald Admin.
Getting an
> > error message as follows:
> >
> > SQL Server Error: 515 Cannot Insert the value NULL into column
'Taxable,'
> > table 'Emerald25.dbo Account Types,' column does not allow nulls. INSERT
> > FAILS. State = 2, severity = 16
> >
> > OK, so I then created a tax item of 6%. But I still get the same error,
no
> > matter whether I leave the taxable field at "none" or at "6%".
> >
> > What's up?
>
> I think that Emerald 2.2 schema had a taxable field on the AccountTypes
> table, when it should not have. Just go into Emterprise Manager, drill
> down to the AccountTypes table, and add a default value to the taxable
> column, value 0, and save the changes. Then you should be fine.
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart