"news.la.sbcglobal.net" <dvsbis@cwnet.com> wrote in message
newsFCAc.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