Re: [Emerald] annual accounts -- autobill = 0 (2.5.236)
Dale E. Reed Jr. ( (no email) )
Fri, 05 Feb 1999 15:14:13 -0800
"Ronnie D. Franklin" wrote:
>
> FYI...
>
> Change one item...
>
> > Where Paymethod = "Credit Card" and CreditCardAutoBill = 0
>
> > Update MasterAccounts
> > Set Paymethod = "Invoice"
> > Where Paymethod = "Credit Card" and CreditCardAutoBill = 1
> > and Exists (Select InvoivceID From Invoices
> > Where MasterAccounts.CustomerID =
> > Invoices.CustomerID
> > and Type = "Credit Card")
Isn't that the second time I've done that? I must need sleep....
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html