Re: Globally changing Expiration dates

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: 2 questions"
Next message: Robert McGuire: "Problem with emerald eval expiring in 2 days"
Maybe in reply to: Barry Kiesz: "Globally changing Expiration dates"
Next in thread: Barry Kiesz: "RE: Globally changing Expiration dates"

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

Previous message: Dale E. Reed Jr.: "Re: 2 questions"
Next message: Robert McGuire: "Problem with emerald eval expiring in 2 days"
Maybe in reply to: Barry Kiesz: "Globally changing Expiration dates"
Next in thread: Barry Kiesz: "RE: Globally changing Expiration dates"