Re: [Emerald] What version of Emerald should we be using?
Dale E. Reed Jr. ( (no email) )
Mon, 01 Mar 1999 23:38:14 -0800
"Ronnie D. Franklin" wrote:
>
> But... if you have changed a "Credit Card" to a "Renewal" without first
> changing Autobill to "0" won't this then reverse ones that you don't want to
> reverse????
>
> The reason I bring this up is that over the past 2 years I am sure that some
> MBRS that are set for Renewal still have Autobill = 1 ...
>
> > This should do it:
> >
> > Update MasterAccounts
> > Set PayMethod = "Credit Card"
> > Where CreditCardAutoBill = 1
> > AND Datalength(CreditCardNumber) >= 13
This assumes that those with CCAutoBill set to 1 and a credit card
number
want to be billed. Yes, there are always the exceptions, I was just
trying
to be generic.
--
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