I don't think you need steps 1 & 5. I know you do not with ODBC, but I am not sure with ADO. Steps 2, 3 and 4 are necessary though.
>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
Mark McCasland
Midlothian, TX USA