Re: Clear Invoices

Dale E. Reed Jr. ( (no email) )
Sun, 26 Apr 1998 23:16:32 -0700

David Moore wrote:
>
> It won't let me delete records from invoices as there are call history
> records if is there a way around this

Yeah. Its gets messy.

Update CallHistory Set ChargeID = NULL
GO
Update InvoiceItems Set PaymentID = NULL
GO
Delete From Payments
GO
Delete From Charges
GO
Delete From InvoiceItems
GO
Delete From invoices
Go

> >You would have to delete them manually. The easiest way to delete them
> >is via isql_w:
> >
> >delete from InvoiceItems
> >Go
> >Delete from invoices
> >go

-- 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