Off the top of my head:
You have to break the link between the CallHistory table and the
ChargeID, and then you can remove the ChargeID. If the charge has
been associated to an invoice, the easiest way is to just void
the invoice, and it will be re-created w/out the charge.
Update CallHistory
Set ChargeID = NULL
Where ChargeID = xxx
GO
Delete From Charges
Where ChargeID = xxx
GO
Where xxx is the charge id. On esome databases, the ChargeID in
CallHistory
may need to be set to 0 not NULL.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com