RE: [Emerald] 2.5.2xx Duplicate Records in CallsHistory

Tom Bilan ( Tom@TDI.NET )
Thu, 25 Feb 1999 08:46:48 -0500

Try using MSQuery, I believe you can hilite individual records and delete
them from there. If there's a problem with the key then remove the key,
delete from msquery, put key back on.

I haven't tried this and if your monitor blows up or other side effects
don't hol dme responsible :) In theory it should work.

Tom

-----Original Message-----
From: ronnie@itexas.net [mailto:ronnie@itexas.net]
Sent: Thursday, February 25, 1999 12:25 AM
To: emerald@iea-software.com
Subject: RE: [Emerald] 2.5.2xx Duplicate Records in CallsHistory

I am not doing usage billing.. I simply want to be able to consolidate....

You had me to setup the indexes.. but unfortunally I had tried to
consolidate prior to that and the consolidation routine wrote about 40
duplicate records in the CallHistory. I tried to delete the records.. but
couldn't.. You stated that I would probably have to use a cursor to get rid
of the records.. Those records are preventing me from adding the proper
indexes to the CallsHistory table.. and thus preventing me from
consolidating....

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Wednesday, February 24, 1999 11:14 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] 2.5.2xx Duplicate Records in CallsHistory
>
>
> "Ronnie D. Franklin" wrote:
> >
> > I am still looking for a way to delete the duplicate records that are in
> > CallsHistory..
>
> What is your key on your CallHistory table? It needs to be changed
> for 2.5 when you are doing any usage billing.
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html