I am using VB6 and SQL 7.0 and ADO 2.6.
I have a form with a datagrid. The table has a Profile Name field and and Record Number field. The first profile must have a 0 for record number, any subsequent can have any other number. There is a trigger that checks to make sure that there is one profile that the record number is 0. Otherwise you get a user defined error.
Now the problem.
I open the form and the ADO connection. Set the datagrid source to the record set. I change the record number to 5, I try to update, and get the error. Good so far. Now I change the record number back to 0 and try to update. I get "Cursor is not open" Error. This is baffling. I try the same thing through enterprise manager and have no problem, after changing rec number back to 0 I am allowed to update.
Please help. Do you need more info? Let me know.
I have a form with a datagrid. The table has a Profile Name field and and Record Number field. The first profile must have a 0 for record number, any subsequent can have any other number. There is a trigger that checks to make sure that there is one profile that the record number is 0. Otherwise you get a user defined error.
Now the problem.
I open the form and the ADO connection. Set the datagrid source to the record set. I change the record number to 5, I try to update, and get the error. Good so far. Now I change the record number back to 0 and try to update. I get "Cursor is not open" Error. This is baffling. I try the same thing through enterprise manager and have no problem, after changing rec number back to 0 I am allowed to update.
Please help. Do you need more info? Let me know.
