Re: Refreshing a current record in a DataSet



Brian,
Does your Query use a Join?
not. Just SELECT * FROM Table

If that is the case you need to set the Resync Command property so that
ADO
knows how to query for the updated values.

Can you please show me the Resync Command property in standard Delphi ADO
componets?
There is no component property you need to set it in code
RecordSet.Properties['Resync command].Value:= 'your SQL value for resyncing'

There is a TadoDataset descendant component that provides Resync Command as a
property and has some other good features for working with ADO
http://betterado.hit.bg/


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

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)
  • Re: "Row cannot be located for updating. Some values may have been changed since it was last re
    ... It appears that ADO's SQL parser is case sensitive ... > the same it will break, but if they are spelled differently (e.g. EMPLOYEE and employee) the ... You should be writing the Resync Command for a joined query not relying on what ... ADO generates. ...
    (borland.public.delphi.database.ado)
  • Re: Blackfish Questions
    ... Craig Stuntz [TeamB] wrote: ... What does Borland/Codegear have against Ado, ... AFAIK Interbase ...
    (borland.public.delphi.non-technical)
  • Re: D9 Rumor Mill: Multiunit namespaces, Win32 enhancements, Refactoring
    ... Dave Nottage (TeamB) wrote: ... Yes, but we were told to say good bye to SQL Links when D6 came out, so ... as Dan Miser suggested and bought 3rd party dbExpress MSSQL driver. ... so we had to give up and go ADO. ...
    (borland.public.delphi.non-technical)