>I'm writing an application where the user can click on grid headers to sort views. This works fine on un-buffered views, but I get an error message (1579 command connot be issued on a table with cursors in table buffering mode) when I index a buffered view. Any ideas?
>
>Thanks,

Josh,

This happens only with table buffered views. Row buffered views don't exhibit this behavior. So, Victor explanation is a right one. You might also switch to row buffering, index and switch back to table buffering. I've been doing this, and I am not alone, for more than 2 years now without any problem.

I do my indesing usually in the Init() of the DataEnvironment:

FUNCTION INIT()
LOCAL luRetVal, ;
lnSelect
luRetVal = EVAL(this.ParentClass+"::Init()")
lnSelect = SELECT()

SELECT v_BatchWageLine
*-- set to Row buffering for index building
CursorSetProp("BUFFERING", DB_BUFOPTRECORD)
INDEX ON cWageHeadId + cCodeJourId TAG HeadCode
INDEX ON cWageHeadId + cTypeRemId TAG HeadTRem
CursorSetProp("BUFFERING", DB_BUFOPTTABLE)
SET ORDER TO TAG HeadCode

SELECT (lnSelect)
ENDFUNC

José