>>>Hi all,
>>>
>>>I am investing what it would take to convert database from local to SQL server. I am looking upsize the tables to SQL and access then via remote views. I realize there far better ways to achieve this other te remote views, but it is a question of time to delievery at stake.
>>>
>>>While, the question I am asking; can index be created against the remote views so I do not have to change all SET ORDER TO stateements?
>>>
>>>Greg
>>
>>Yes, but you must be sure that RV is not opened with Table Buffering. If you need that View to be opened that way, before INDEX it switch to RowBuffering:
>>
>>CURSORSETPROP([Buffering],3, [YourViewAlias])
>>INDEX ON .....
>>CURSORSETPROP([Buffering],5, [YourViewAlias])
>>
>
>Thanks for the tip.
>
>Does the index persist after the RV is closed?
No, RV is not a table, it is just definition of the cursor and how that cursor is related to Remote source. You must INDEX it ALL the time. That is why I prefer to work with CursorAdapter, I easily can put my INDEX code in AfterCursorFill event (of course if it is successful) and have all the indexes all the time I use it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.