Re: Globally changing Expiration dates

Dale E. Reed Jr. ( (no email) )
Wed, 23 Apr 1997 15:07:49 -0700

Barry Kiesz wrote:
>
> I need to globally change all of my expiration dates due to the fact that
> we currently do not have the accounting "thing" going and People are
> starting to expire! I not real familiar with SQL so if someone could map
> out a solution. I would appreciate it greatly!!

Run this in iswl_w:

Update MasterAccounts
Set maExpireDate = "6/1/97"

or, better yet:

Update MasterAccounts
Set maExpireDate = "6/1/97"
Where maExpireDate < "6/1/97"

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com