Row can not be located ... on Delete

D5, MS SQL 2000.

I have a dataset which joins 3 tables:

SELECT CIV_HEAD.*, CIV_PLAINTIFF.LAST_NAME,
CIV_PLAINTIFF.FIRST_NAME, CIV_PLAINTIFF.MIDDLE_NAME,
CIV_DEFENDANT.BUSINESS_NAME, CIV_DEFENDANT.LAST_NAME,
CIV_DEFENDANT.FIRST_NAME, CIV_DEFENDANT.MIDDLE_NAME
FROM CIV_HEAD LEFT JOIN CIV_PLAINTIFF ON CIV_HEAD.ID = CIV_PLAINTIFF.RID
LEFT JOIN CIV_DEFENDANT ON CIV_HEAD.ID = CIV_DEFENDANT.RID

All 3 tables have AutoInc ID field defined as primary key.

When i am trying to delete a record, it raises exception

Row cannot be located for updating. Some values may have been changed since
it was last read.

What am i missing? I expect Delete to remove the record from CIV_HEAD
table...

Thanx,
Eugene.


.

Relevant Pages

  • Re: SQL Express - Identity specification property - how to change
    ... FOO_ID int identity, ... Tony Rogerson, SQL Server MVP ... They are making unfortunately frequent use of the IDENTITY column in conjunction with Primary Key. ... IDENTITY has none of the properties of a data type because it is not a data type at all. ...
    (comp.databases.ms-sqlserver)
  • Re: Binding and adding rows with SQL identity column
    ... Each time you call AddNew then the DataTable generates a new ... Each time an update is done then the real primary key ... > generated by the built-in wizard in VS2003. ... > identity column on the sql table, perhaps this would all the fine and I ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: What happens after 2^32 autonum keys are exhausted?
    ... Tony Rogerson, SQL Server MVP ... generated primary key despite the risk of a hardware or software error or a fault in the space-time continuum. ... identifier and have to invent one, follow the data design (data ...
    (comp.databases)
  • Re: sliced find in Linq
    ... by over all of the returned columns. ... Since the original query was unordered, I'd like the above SQL to ... (Perhaps your table doesn't have a primary key though?) ... didn't specify the ordering, so any ordering could have been used. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Can a query find info X numbr of rows from target info?
    ... "Ann Scharpf" wrote: ... > each row is sequentially numbered, giving me the desired explicit sort order. ... > an exact comparison between my SQL & your advice. ... Do you have Row names (Primary Key). ...
    (microsoft.public.access.queries)