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