Re: [Emerald] Can't delete MBR

WayneG ( (no email) )
Mon, 28 Jun 1999 16:37:52 -0500

O.K. I deleted all payments and charges and voided all invoices, except one
Charge that causes the same 547 Error listed below when I try to delete it.
-Wayne

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Monday, June 28, 1999 2:44 PM
Subject: Re: [Emerald] Can't delete MBR

>WayneG wrote:
>>
>> I get the following errors when trying to delete a certain MBR with ver
>> 2.5.278:
>>
>> SQL Server Error: 547 DELETE statement conflicted with COLUMN REFERENCE
>> constraint 'FK_CallHisto_Charg_471C9436'. The conflict occurred in
database
>> 'Emerald', table 'CallHistory', column 'ChargeID' State= 2, Severity= 16
>> SQL Server Error: 3621 Command has been aborted. State= 0, Severity= 0
>> Error Deleting Charges Items
>>
>> Also, when trying to VOID an invoice in this account, I get a "Run-time
>> error '13' Type mismatch" and Emerald closes.
>
>Go into the MBR, and delete any charges from the history list that
>is associated to a usage charge. Then you should be able to
>delete the MBR. This should be fixed in the next update.
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com