-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Ronnie D. Franklin
Sent: Friday, February 05, 1999 3:25 PM
To: emerald@iea-software.com
Subject: RE: [Emerald] annual accounts -- autobill = 0 (2.5.236)
Yes.... but then again I am not sure you ever sleep!!!
> > 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)
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