Re: [Emerald] Changing Permanent Expire...

David Routh ( )
Wed, 15 Sep 1999 18:02:41 -0500

OK, here's another... please correct me if I'm wrong:

>update masteraccounts
>set overdue=[new value]
>where overdue=[old value]

update masteraccounts
set paidthru=9/30/1999
where paidthru=10/1/1999

Would this set all the MBR's that have a Paid Thru of 10/1/99 to 9/30/99?

What happened is when we started inputting customers into Emerald we set
the Paid Thru and Expire and Billed Thru dates as 10/1/1999 where we should
have put them to 9/30/1999 which is what they are actually paid thru...

Basically, I'd like to change all the Paid Thru, Expire and Billed Thru
that are 10/1/1999

Thanks, still learning...

For more information about this list (including removal) go to: