Re: [Emerald] Can't delete MBR

Dale E. Reed Jr. ( (no email) )
Mon, 28 Jun 1999 12:47:40 -0700

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.