
MS Datagrid - Delete Fails with SQL ADO recordset
I am trying to bind a SQL ADO recordset to - MS dataGrid 6.0.
2 Questions.
1. Unless I use a clientside cursor, I get an error stating that "the
recordset is not bookmarkable" or something along those lines.
What do I need to do to use a server side cursor?
2. Using the clientside cursor I have managed to bind the recordset to
the datagrid. I am able to add new records and update existing ones. When
I delete, it appears to work but when I move to another record and come back
the record is there again. I have permissions, I have delete
enabled, I have updated my recordset, and refreshed my datagrid. But still,
it is not working - can anyone give me some pointers?
Thanks very much.
Brian Foster.