[Emerald] SQL SCRIPT! PLEASE VERIFY!

webmaster ( (no email) )
Fri, 18 Jun 1999 10:40:37 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_0023_01BEB977.00971260
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need to change all invoice customers to quarterly billing... wil this =
sql script do that....

Update MasterAccounts set PayPeriod=3D'Quarterly' where Paymethod=3D =
'Invoice'

also i seem to have a problem with emerald changing credit card =
customers to invoice could you give me a script that would change them =
back?

Kenneth Jaeger

------=_NextPart_000_0023_01BEB977.00971260
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

I need to change all invoice customers to quarterly=20billing...  wil this sql script do that....
 
Update MasterAccounts set PayPeriod=3D'Quarterly' =where=20Paymethod=3D 'Invoice'
 
also i seem to have a problem with emerald changing =credit=20card customers to invoice could you give me a script that would change =them=20back?
 
 
Kenneth Jaeger
------=_NextPart_000_0023_01BEB977.00971260--