Operation Was cancelled Error
-
i am having my project in vb6.0,i have binded my controls at design time with Maindata(RecordSet). Now i am binding DataCombo control at runtime(with new RECORDSET),when i am writing this code i am getting error in other events when my maindata(recordset)is getting updated.error is "Operation was cancelled" wt clould be the reason??????? This is the code, Set PartyData = New ADODB.Recordset PartyData.CursorLocation = adUseClient If PartyData.state = adStateOpen Then PartyData.Close PartyData.Open "select StkSuppliersMaster.name from StkSuppliersMaster join purinqparty on StkSuppliersMaster.code=purinqparty.suppliercode where purinqparty.mastid=(select id from purinqmaster where inqno=" & txtInqNo.Text & ")", db, adOpenStatic, adLockPessimistic Set dbcParty.RowSource = PartyData above code works fine if i write, PartyData.Open "SELECT * FROM StkSuppliersMaster order by Name", db, adOpenStatic, adLockPessimistic GIRISH
-
i am having my project in vb6.0,i have binded my controls at design time with Maindata(RecordSet). Now i am binding DataCombo control at runtime(with new RECORDSET),when i am writing this code i am getting error in other events when my maindata(recordset)is getting updated.error is "Operation was cancelled" wt clould be the reason??????? This is the code, Set PartyData = New ADODB.Recordset PartyData.CursorLocation = adUseClient If PartyData.state = adStateOpen Then PartyData.Close PartyData.Open "select StkSuppliersMaster.name from StkSuppliersMaster join purinqparty on StkSuppliersMaster.code=purinqparty.suppliercode where purinqparty.mastid=(select id from purinqmaster where inqno=" & txtInqNo.Text & ")", db, adOpenStatic, adLockPessimistic Set dbcParty.RowSource = PartyData above code works fine if i write, PartyData.Open "SELECT * FROM StkSuppliersMaster order by Name", db, adOpenStatic, adLockPessimistic GIRISH
try adLockOptimistic.... May be then it works
colgateas900197
-
try adLockOptimistic.... May be then it works
colgateas900197
thanks for ur reply i will try and let u know.
-
i am having my project in vb6.0,i have binded my controls at design time with Maindata(RecordSet). Now i am binding DataCombo control at runtime(with new RECORDSET),when i am writing this code i am getting error in other events when my maindata(recordset)is getting updated.error is "Operation was cancelled" wt clould be the reason??????? This is the code, Set PartyData = New ADODB.Recordset PartyData.CursorLocation = adUseClient If PartyData.state = adStateOpen Then PartyData.Close PartyData.Open "select StkSuppliersMaster.name from StkSuppliersMaster join purinqparty on StkSuppliersMaster.code=purinqparty.suppliercode where purinqparty.mastid=(select id from purinqmaster where inqno=" & txtInqNo.Text & ")", db, adOpenStatic, adLockPessimistic Set dbcParty.RowSource = PartyData above code works fine if i write, PartyData.Open "SELECT * FROM StkSuppliersMaster order by Name", db, adOpenStatic, adLockPessimistic GIRISH