[Emerald] Re: [RadiusNT] Deleting Old Invoices

Dale E. Reed Jr. ( (no email) )
Thu, 18 Mar 1999 12:10:37 -0800

Ed Miller wrote:
>
> When we try to delete old invoices. (Invoices not made under 2.5) we get a
> runtime Error '13' Type mismatch' then Emerald just quits.
> We have tried this with several versions. 2.5.236 - 255 - 265 all with same
> results.
> We really need to delete and re-issue some very old invoices. Any
> suggestions??

Run this query:

Update Invoices
Set PreviuosBalance = 0
Where PreviousBalance is NULL

and it will correct the problem.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html