SEO

#1 (**permalink**) 02-29-2008, 03:17 AM

hi all
i am trying to update or delete a row/record in table cptcodes
the error i am getting is

key column information is insufficient or incorrect to many rows
were affected by update....

can you tell me wat causes the above Error
this is a new table no primary keys set or index's or constraints just a
single table with some data
in it...all columns are char nulls allows except the key field but no
primary set as yet

thanks for the help
dave

#2 (**permalink**) 02-29-2008, 03:17 AM

"news.la.sbcglobal.net" <dvsbis@cwnet.com> wrote in message
news

FCAc.4688$zl3.3983@newssvr27.news.prodigy.co m...
> hi all
> i am trying to update or delete a row/record in table cptcodes
> the error i am getting is
>
> key column information is insufficient or incorrect to many rows
> were affected by update....
>
> can you tell me wat causes the above Error
> this is a new table no primary keys set or index's or constraints just a
> single table with some data
> in it...all columns are char nulls allows except the key field but no
> primary set as yet
>
> thanks for the help
> dave
>
>

Your error message doesn't seem to be a standard MSSQL error, so I guess
it's coming from your client library, ie. ADO or whatever. In any case, the
problem is most likely because you have no primary key - some clients will
not update/delete a table without a primary key, because with no key it's
not possible to identify which rows should be modified. So I would add a key
and see if that fixes the error - you should always have a primary key on
all tables anyway.

If this doesn't help, perhaps you can give some more information, especially
the CREATE TABLE statement and also which client tool/library you're using.

Simon

#3 (**permalink**) 02-29-2008, 03:17 AM

Hi

This sort of message appears in EM when you don't have a PK and you choose
to delete the row as it can not distinguish the row, so I guess it will
disappear if you added a PK.

John

"news.la.sbcglobal.net" <dvsbis@cwnet.com> wrote in message
news

FCAc.4688$zl3.3983@newssvr27.news.prodigy.co m...
> hi all
> i am trying to update or delete a row/record in table cptcodes
> the error i am getting is
>
> key column information is insufficient or incorrect to many rows
> were affected by update....
>
> can you tell me wat causes the above Error
> this is a new table no primary keys set or index's or constraints just a
> single table with some data
> in it...all columns are char nulls allows except the key field but no
> primary set as yet
>
> thanks for the help
> dave
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

sql server service pack 3 update, delete question or problem