Re: Emerald Digest for 30 May 1997

Dale E. Reed Jr. ( (no email) )
Mon, 02 Jun 1997 22:40:40 -0700

Jeffrey Betts wrote:
>
> Hi I know there is going to be utilities
> in the future to manage the size of the
> emerald database. Is there anything I can do
> now to shrink it

The best is:

Delete From Calls
Where CallDate < '3/1/97'
And AcctStatusType = 1

Execute this, then increment the date until you are at 6/1/97 and it
will
generally clear out a lot of records.

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