VB & Database, recordset.update updates

recordset.update updates > 1 row

Author	Message
Mark Heat #1 / 3	recordset.update updates > 1 row I am using VB6 SP3 on Win2000 with ADO2.1 referenced in my project. I am opening a recordset with the following SQL: SELECT oh_lock FROM Order_Header WHERE oh_id = '1' (oh_id is the key field and this SQL returns 1 row) I then write to the database on the following condition: If (rst!oh_lock & "") = "" Then rst!oh_lock = "hello" rst.Update Else ... The trouble is, this sets oh_lock in ALL records in Order_Header where oh_lock is null to "hello". I can fix this by changing the SQL to: SELECT oh_id, oh_lock FROM Order_Header WHERE oh_id = '1' Now, only 1 row (ie where oh_id = '1') will be updated. Is this a bug or is this supposed to happen? It doesn't seem right to me. Mark ps I am using Access database, adLockOptimistic and adOpenForwardOnly
Fri, 27 Sep 2002 03:00:00 GMT

John W. Rug #2 / 3	recordset.update updates > 1 row I don't understand your question. You queried for and found one record and then you updated that one record? Quote: > I am using VB6 SP3 on Win2000 with ADO2.1 referenced in my project. > I am opening a recordset with the following SQL: > SELECT oh_lock FROM Order_Header WHERE oh_id = '1' > (oh_id is the key field and this SQL returns 1 row) > I then write to the database on the following condition: > If (rst!oh_lock & "") = "" Then > rst!oh_lock = "hello" > rst.Update > Else ... > The trouble is, this sets oh_lock in ALL records in Order_Header > where oh_lock is null to "hello". > I can fix this by changing the SQL to: > SELECT oh_id, oh_lock FROM Order_Header WHERE oh_id = '1' > Now, only 1 row (ie where oh_id = '1') will be updated. > Is this a bug or is this supposed to happen? It doesn't seem right to me. > Mark > ps I am using Access database, adLockOptimistic and adOpenForwardOnly
Thu, 03 Oct 2002 03:00:00 GMT

Mark Heat #3 / 3	recordset.update updates > 1 row Quote: > I don't understand your question. You queried for and found one record and > then you updated that one record? More than one record gets updated with "hello" in the oh_lock field. Another fix I found was to use adOpenDynamic instead of adOpenForwardOnly. Mark Quote: > > I am using VB6 SP3 on Win2000 with ADO2.1 referenced in my project. > > I am opening a recordset with the following SQL: > > SELECT oh_lock FROM Order_Header WHERE oh_id = '1' > > (oh_id is the key field and this SQL returns 1 row) > > I then write to the database on the following condition: > > If (rst!oh_lock & "") = "" Then > > rst!oh_lock = "hello" > > rst.Update > > Else ... > > The trouble is, this sets oh_lock in ALL records in Order_Header > > where oh_lock is null to "hello". > > I can fix this by changing the SQL to: > > SELECT oh_id, oh_lock FROM Order_Header WHERE oh_id = '1' > > Now, only 1 row (ie where oh_id = '1') will be updated. > > Is this a bug or is this supposed to happen? It doesn't seem right to me. > > Mark > > ps I am using Access database, adLockOptimistic and adOpenForwardOnly
Fri, 04 Oct 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]