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

Dale E. Reed Jr. ( (no email) )
Tue, 02 Mar 1999 00:50:21 -0800

"Ronnie D. Franklin" wrote:
>
> 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.....

That won't help, because the incorrect entries will have Renewal/1 and
you change them to 0. Then the below doesn't affect any of them.

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