I am facing 2 inexplicable problems using ADO recordset in VB6 with SQL Server:
1) After populating data-bound TextBoxes with data if I delete the value in a TextBox & then execute the Update method,I observed that the value doesn't change at the backend.That is the value should now be NULL.But the original value remains intact.
2) If I delete the value in a TextBox & then programmatically assign a value to another field in the same recordset object & then Update,I get this error:
Multi-step operation generated errors.Check each status value.
What is the problem?Although sans deleting the value if I just alter it then the data is properly saved.