>>>>>>>Is there a way to index a view so I can do a seek?
>>>>>>
>>>>>>Trish, just SELECT you view and index it as if it is a table.
>>>>>
>>>>>But I have to write to to it and want to use the buffering. Plus, if we upgrade to SQL server we have been trying to just use views.
>>>>
>>>>You stil wil be able to update the indexed view, and you are just limited to use only row buffering for your view. For indexing purpose it doesn't matter which view you are using -local or remote.
>>>
>>>I can't use table buffering?
>>
>>No, if you try - you will get the message "Command cannot be issued on a table with cursors in a table buffering mode".
>>But you are able to switch to row buffering, index, seek and then return to table buffering mode, of course if it is not interfering with other conditions and requerements which you have in your form.
>
>
>Let me get this straight. I can switch to row buffering or even turn it off to build the index. Then set it to table buffering. Right before I do I seek, I change it to row buffering and when the seek if done, I can set it back to table buffering before I make any changes. This way, at the end of my processing, I can do a full tableupdate.
>
>Is this right?

This is not right. You switch to row buffering only to index a view. When you do SEEK you shouldn't do it again.