"news.la.sbcglobal.net" <dv****@cwnet.com> wrote in message
news:oF*****************@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