> Kelly Wright wrote:
> >
> > How do you add this key mentioned.
>
> Go Into Enterprise Manager, drill down into your Emerald Database
> and double click the calls table. Click the Advanced Options button
> and on the Primary tab (the first one) click remove. Then re-add the
> following fields in the following order:
>
> AcctSessionID
> NASIdentifier
> AcctStatusType
> Username
>
> and click save.
Dale,
Thanks for the start but i have a problem.
I do not have Username in the list of selections. I have UsernameOld but
that is not used anymore.
How do I get Username in the list so I can enter it as a kay?
Ed Miller
>
> > Kelly Wright (kelly@buz.net)
> >
> >
> > Ed Miller wrote:
> > >
> > > ODBC Error:23000:2627:
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY
KEY
> > > constra
> > > int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
> >
> > The reason why this isn't showing up is because its a duplicate
> > accounting record. You may need to add username to the primary
> > key if you get this a lot.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart