I'm using the CursorAdapter with the ADO datasource type to obtain data from a SQL Server table. I want the cursor to user optimistic table buffering. Once I get the cursor back, I'd like to create an index on the cursor for lookups while I'm updating it. When doing so, I get the error "Command cannot be issued on a table with cursors in table buffering mode" (Error 1579).
It appears that I can get around this by:
(1) Doing a CursorDetach()
(2) Changing to row buffering
(3) Creating the index
(4) Changing to table buffering
(5) Doing a CursorAttach()
This seems like the long way around the barn.
Can anyone suggest a better way to create an index on this cursor?
Thanks,
Scott
Scott King
The Support Source Corporation