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. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart