error in updating record when CheckRowVersion=True

[siatc1]

I have set the CheckRowVersion=True in the MSQuery component.
When I perform the first applyupdate, there is no error. After that I continue and change some data and then applyupdate again, it gives me the error "Update Failed. 0 records".

I believe that after my first applyupdate, the timestamp field in the record has been changed. But even if I set RefreshOptions.roAfterUpdate it doesn't help on my second applyupdates.

[Ikar]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next SDAC build. Please look forward for announcements at the forum.

[jigesh]

Thank you for information.
It seems like the problem is not fixed. I am using SDAC 3.70.1.25. My first update goes ok without errors, but my next update gives me an error message saying "Update Failed. Found 0 record."

CAn you please help me resolve this problem. I am stuck on this problem now for ouple of weeks.

I have tried all other solutions that were offered for this problem.

All your help will be really appreciated.

Thanks

[Antaeus]

Try downloading last version of SDAC (3.70.1.26). If problem persists then send us complete small sample to demonstrate it, including script to create server objects.
Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MS SQL server. You can see it in Info sheet of TMSConnection Editor

[jigesh]

Hi

My problem was solved by refreshing the table in the BeforeEdit event of the table.

Thanks for all the help