>>>>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.
>
>
>Have you tried to index to an IDX
>
>INDEX ON whatever TO delme.idx
>
>I don't know how this works on SQL
>
>Charles
You can index (cdx) both local and remote views the same way as ordinary cursor.
Edward Pikman
Independent Consultant