However the current isue is that i Have no call details for the previous
months that were consolidated.
So what I want to do is restore the data from a backup and copy all the
call details information into this table and then i can point the web page
to this page.
Obviously our current data has been consolidated into the call history table.
It should look like this.
OLD emerald database pre consolidation ----- into ----- new call details
At 03:09 PM 7/14/98 -0700, you wrote:
>See this post in the archives:
>Ian Pizey wrote:
>> Does any one know how to copy the calls table within the emerald
>> database to another
>> table that can be used for archive purposes. That in turn can be used for
>> user time look ups.
>> The table would have a different name and contain the same structure and
>> data as the current table. i asssume that once the table is created a
>> nightly trigger can update this table and therefore have near on line time
>> available for the users. I realize that the purpose of the consolidation
>> process is to reduce the amount of data in the calls table. However the
>> need for online time checking does save a needless administrative burden
>> and provides the customers with better service.
>Many sites are using this and it works well.
>Dale E. Reed Jr. (firstname.lastname@example.org)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8