> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Robert H. Clugston
> Sent: Friday, February 05, 1999 5:38 PM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] annual accounts -- autobill = 0 (2.5.236)
>
>
> Who in the ISP business gets to sleep?
>
> -----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
>
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html