Re: [Emerald] Re: [RadiusNT] Deleting Old Invoices

Ed Miller ( (no email) )
Thu, 18 Mar 1999 16:02:30 -0500

Get the follwing error:

Msg 207, Level 16, State 1
Invalid column name 'PreviuosBalance'.

There is a column named 'PreviousBalance' ???
Did do something wrong?

>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

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