>>I'm trying to index a view from a remote SQL Server 6.5 table.
>>
>>I'm using the view with buffering :
>>
>>USE rfi nodata in 0
>>=CURSORSETPROP('Buffering',5,'rfi')
>>
>>
>>When I do :
>>index on lordem tag lordem
>>
>>I get the error :
>>"Command cannot be issued on a table with cursors in table buffering mode"
>>
>>I need to index the view in order to the new records added to the view show up to the user in a certain order.
>>
>>Thanks for your help,
>>
>>Ricardo
>
>Ricardo,
>
>Simply the index the cursor before you change the buffering mode.
>
>HTH

Thanks for your answer but it didn't solve the problem :

I tried to index before change the buffering mode, but the view is created with row buffering by default.

Then i tried to stop the buffering with the following command :

=CURSORSETPROP('Buffering',1,'rfi')

and i got this error :

"Views require either DB_BUFOPTROW or DB_BUFOPTTABLE."

What else can i try ?