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

Ronnie D. Franklin ( ronnie@itexas.net )
Tue, 2 Mar 1999 01:46:32 -0600

What if you assume that all the MBRS are set to bill properly from the
start.. and first run a query to change all "Renewals" that have "Autobill =
1" to "Autobill = 0" then do the query that you have.....

> > > 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.

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html