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.

For more information about this list (including removal) go to: