Row cannot be located for updating sql server problems dating single

Hello I am using VB6, SQL server 2000, and ADO 2.5, and saw this problem recently.

row cannot be located for updating sql server-57

Open("select * from t1 where id=1", cn, ad Open Static, ad Lock Optimistic) . Update ' //error here: Row cannot be located for updating. Is there text in the combo boxes before the sql is called? Record Source = "select Roll No, Name, " cmb Month. That a way that SQL distinct rows with same values and rest of code should work... Move Next and applying same changes or use UPDATE SQL syntax for updating all records that match criteria.Text " from Lectures Attended where Subject Name='" cmb Subject. But this Syntax will update only current record If you have , for example , record like this where Subject Name is equal Sr No, Student ID, Roll No, Name, Subject Name, June,..., March 1 XXX YYY ZZZ AAA BBB 2 XXX YYY ZZZ AAA BBB 3 XXX YYY ZZZ AAA BBB 4 XXX YYY ZZZ AAA BBB 5 XXX YYY ZZZ AAA BBB After first update you will face this situation Sr No, Student ID, Roll No, Name, Subject Name, June,..., March 1 XXX YYY ZZZ AAA New Value 2 XXX YYY ZZZ AAA BBB 3 XXX YYY ZZZ AAA BBB 4 XXX YYY ZZZ AAA BBB 5 XXX YYY ZZZ AAA BBB Only first record after select is updated... Also one suggestion, is there any possibility to avoid using column for months?The solution required tweaking a small setting in the ODBC DSN property as shown below Once we set the Return matched rows instead of affected rows option the UPDATE query executed successfully.

This setting will allow the updating of values in My SQL to the fields which has a value already.

The client side is vb6 and using Dcom dll's hosted on the db server. My first guess is that something is wrong with your code, or possibly your data. We understand that you've got a problem, and that your problem involves two different vehicles made in two different years, but we don't understand exactly what you've tried, what results you've gotten, and what you expected.

I have a table which has oninsert trigger When the recordset is updated in the com class it throws the foll error : "Row cannot be located for updating. What you've done in this post is something like saying "My screwdriver works in my 2000 Toyota, but not in my 2005 Toyota. In other words, we have almost nothing to work with when we try to help you.

Some values may have been changed since it was last read.

How to repeat: Create a table with float not null column mysql insert into t1(f) values(144.977477477477); Query OK, 1 row affected (0.02 sec) ** use the same value: 144.977477477477 Create a project in VB6 w/ a Form & Command button: Private Sub Command1_Click() Dim cn As New ADODB.

This blog explains an issue you're likely to face while executing a remote UPDATE query against a My SQL server over a linked server connection using ODBC DSN based connectionstring Recently I was working in a project where I required data to be transferred from a remote server and do some manipulations with it.