Set PayMethod = "Credit Card"
Where CreditCardAutoBill = 1
AND Datalength(CreditCardNumber) >= 13
AND PayPeriod = "Monthly"
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com]On Behalf Of Ronnie D. Franklin
> Sent: Tuesday, March 02, 1999 2:36 AM
> To: firstname.lastname@example.org
> Subject: RE: [Emerald] What version of Emerald should we be using?
> 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
> 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
> 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