update masteraccounts
set sendmethod=0 -- Postal Mail
where sendmethod=1 -- Email - Text
or sendmethod=2 -- Email - HTML
Emerald translates the numeric values to the text when you see it in
Emerald. The names aren't stored in the database anywhere. 3 represents
"None".
Josh
> ----- Original Message -----
> From: "Josh Hillman" <admin-maillist@talstar.com>
> To: <emerald@iea-software.com>
> Sent: Thursday, May 25, 2000 2:19 PM
> Subject: Re: [Emerald] billing type
>
>
> > From: Jeremiah Fulbright <support@pwtel.net>
> > > IS there a query that can be ran to change all Invoice types from
Email,
> > to
> > > Postal Mail?
> >
> > update masteraccounts
> > set sendmethod=0
> > where sendmethod=1
> >
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart