You can't index a table that is in table buffering mode. The SELECT-SQL is probably just doing a SET FILTER on the MyTable table, so the INDEX ON fail because MyTable is table buffered. Remove the CURSORSETPROP("buffering", 5) line and the INDEX ON will run without errors.

HTH

---

>How do I INDEX my cursor if SET DELETED OFF when buffering?
>
>I get error with the following code:

>SET DELETED OFF
>SET MULTILOCK ON
>USE mytable AGAIN SHARED
>CURSORSETPROP("buffering", 5)
>
>SELECT f1, f2 ;
>   FROM mytable ;
>   WHERE f1 = "111" ;
>   INTO CURSOR mycursor
>
>INDEX ON f1 TAG f1 OF mycdx.cdx
>&& ERROR - 1579 Command cannot be issued on a table with cursors in table buffering mode.