Re: [Emerald] Creating New Service
Dale E. Reed Jr. ( (no email) )
Wed, 03 Nov 1999 15:34:21 -0800
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