Hi All,
I am getting this one again.
I have an ADO Query that I am doing an Edit and a Post with.
If the data stays the same, there is now problem
----------------
qry.Edit;
qry.Post;
----------------
the moment I set just one field, I get "Row cannot be located for
updating. Some values may have been changed since it was last read"
----------------
qry.Edit;
qry.FieldByName('Value').AsString := 'Bob';
qry.Post;
----------------
Now I know that this is an issue to do with ADO and MDAC and how
Delphi is using it, but is there anything that I can do to fix this.
I have tried all the other hints ( like setting the qry.Properties
['Update Criteria'].Value := 0;) but nothing has helped.
Please can someone help me out with this, I am desperate now :(
I am using Delphi 7 with the latest MDAC installed.
I have not put on the 7.1 update as I get the DataSet errors that
where created by the 7.1 update (even with the database supplimental
added).
Like I said, any suggessions would be greatly appreciated.
Thanks
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
