RE: [Emerald] 2.5.2xx Duplicate Records in CallsHistory

Ronnie D. Franklin ( ronnie@itexas.net )
Thu, 25 Feb 1999 09:29:01 -0600

Tried that... the records are keyed and linked to the Service so SQL says no
way.......

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Tom Bilan
> Sent: Thursday, February 25, 1999 7:47 AM
> To: 'emerald@iea-software.com'
> Subject: RE: [Emerald] 2.5.2xx Duplicate Records in CallsHistory
>
>
> 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
>

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