Re: [Emerald] Can't delete MBR

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] Help HELP HELP"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Limiting number of hours per month"
Maybe in reply to: WayneG: "[Emerald] Can't delete MBR"
Next in thread: WayneG: "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

Previous message: Dale E. Reed Jr.: "Re: [Emerald] Help HELP HELP"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Limiting number of hours per month"
Maybe in reply to: WayneG: "[Emerald] Can't delete MBR"
Next in thread: WayneG: "Re: [Emerald] Can't delete MBR"