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

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/14/04

  • Next message: Brian Bushay TeamB: "Re: XP SP2 and "SetFileSecurityI"" 
    Date: Mon, 13 Dec 2004 22:19:01 -0600

    >You are right Brian I would lose that bet. I was able to verify that the problem lies in the
    > ADO recordset implementation. It appears that ADO's SQL parser is case sensitive
    > ( I could not believe it ) and if the table name in the FROM clause and in the join is exactly
    > the same it will break, but if they are spelled differently (e.g. EMPLOYEE and employee) the
    > Update works. As soon as I do this however ADO stops recognizing the "Unique Name"
    > property as a valid property and throws and error 'Unique table is nonexistent or not
    > completely specified.' I have to have the 'Unique Table' property however so that my
    >Resync command is generated with the correct primary key atom.
    You should be writing the Resync Command for a joined query not relying on what
    ADO generates. Maybe that will handle your problem.
    Unique table should only be affecting Deletes
    You may want to use TBetterAdoDataset
    http://betterado.hit.bg/
    This TadoDataset defendant makes using Resync Command and a lot of other ADO
    properties a lot easier. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Brian Bushay TeamB: "Re: XP SP2 and "SetFileSecurityI""

    Relevant Pages

    • "Unique Table" and "Resync Command" problems with self-ref query
      ... I am unable to use "Unique Table" and "Resync Command" ... properties with self-referencing queries in ADO 2.8. ... FROM EMPLOYEE LEFT OUTER JOIN EMPLOYEE AS E2 ON E2.employee = ... e2.employeename as supname FROM EMPLOYEE LEFT OUTER JOIN ...
      (microsoft.public.data.ado)
    • Re: "Row cannot be located for updating. Some values may have been changed since it was last re
      ... >pretty sure my 'Resync Command' works although it never gets to resyncing. ... >Obviously it will think that a row is deleted since there is no way employee is the guid and is null at the same time. ... >This example does not use adCriteriaKey but if I did the effect would be the same it just ... If I open the ADO recordset and then assign it to the TADOQuery it works as well. ...
      (borland.public.delphi.database.ado)
    • Create Temporary Tables in a SQL Statement?
      ... there is an employee table. ... We pay bi-weekly so I have to created a query against the employee ... This table is then checked against the time sheets table per employee ... dates in ADO then insert the query into another query through ado to ...
      (microsoft.public.access.queries)
    • Re: Refreshing a current record in a DataSet
      ... Can you please show me the Resync Command property in standard Delphi ADO ... Brian Bushay (TeamB) ...
      (borland.public.delphi.database.ado)