>>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é

Thanks for the info, Jose.