>>>>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."
>>
It worked ! Thank you very much.
>>What else can i
>
>=CURSORSETPROP('Buffering',3,'rfi')
>*** index your view now
>=CURSORSETPROP('Buffering',5,'rfi')
Ricardo Parreira
PHC
Portugal