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

=CURSORSETPROP('Buffering',3,'rfi')
*** index your view now
=CURSORSETPROP('Buffering',5,'rfi')