Re: Inserting Licence and Company Name SQL Error

Dale E. Reed Jr. ( (no email) )
Thu, 11 Dec 1997 09:35:50 -0800

Paul Verney wrote:
>
> Hello,
> I am still having problems trying to insert the Liscence Key and Company.
>
> after entering
>
> insert into Liscenses (LiscenseID,Company)
> values("yourlicense","company")
>
> in ISQL-w (Thanks for your help David Inman)
>
> I get the following error Message:
> Which translated is (hopfully good enought for you to understand)
>
> News.-Nr. 2627, level 14 Status1
> Injuring the PRIMARY KEY restrictions 'pk_Liscenses": Trying, insert Keycopy into Liscenses
> Commandorder stoped
>
> Whats happening and what can i do ?

Is it possible that the key is already in there? If you do a "Select * From
Liscenses" does it show up?

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