RE: [Emerald] What version of Emerald should we be using?

Bernard Andrys ( (no email) )
Tue, 2 Mar 1999 13:08:15 -0500

Couldn't you just add
"AND PayPeriod = "Monthly"
So that people that converted from monthly to yearly wouldn't get messed up.

Update MasterAccounts
Set PayMethod = "Credit Card"
Where CreditCardAutoBill = 1
AND Datalength(CreditCardNumber) >= 13
AND PayPeriod = "Monthly"

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Ronnie D. Franklin
> Sent: Tuesday, March 02, 1999 2:36 AM
> To: emerald@iea-software.com
> 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
> 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
>
>
> 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