Re: [Emerald] Can't delete Charge

Dale E. Reed Jr. ( (no email) )
Thu, 01 Jul 1999 10:17:54 -0700

WayneG wrote:
> I get the following errors when trying to delete a certain Charge 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
> I have voided all invoices on this account and deleted all other Charges and
> Payments,
> but I can not delete this last remaining Charge.
> I am trying to delete the MBR, but that produces the same error.

This is because there is a CallHistory that points to that charge. To
delete the charge, note the ID of the charge in the History window,
and run this SQL Statement:

Update CallHistory
Set ChargeID = NULL
Where ChargeID = x

Replace x with the ChargeID. After running that, you should be able to
delete the charge.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: