RE: Globally changing Expiration dates

Barry Kiesz ( barry@mdex.net )
Fri, 25 Apr 1997 13:26:13 -0500

Thanks a ton, Dale. It worked like a charm... I would love to learn more about this SQL if I had the time..

Barry

On Wednesday, April 23, 1997 5:08 PM, Dale E. Reed Jr. [SMTP:daler@iea.com] wrote:
> 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
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com