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