Re: [Emerald] Changing CreditCard to Renewal
Dale E. Reed Jr. ( (no email) )
Wed, 25 Aug 1999 15:06:23 -0700
Tommy Cheng wrote:
>
> yeah, i know.
>
> i should of typed 2.5.278.
>
> I just need a version that doesn't add a $0 charge for every new customer i
> have.
>
> and the worst part, i don't know how to fix it.
>
> any sql tricks to make this "$0 charge" go away?
Try this:
delete from charges
where Amount = 0
You have to do it before you run invoices, though.
--
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