>>Hello all
>>
>>I was wondering was their any way to have a index of any kind of a remote view?
>>
>>Just trying to solve everyday prolonged data access problems
>>
>>Thanks in advance for any and all help
>>Stephen McLaughlin
>>"Blastmaster"
>>krsone@charm.net
>
>Yes. For best performance, your remote source table should have indexes to speed up the retrieval process. When you create your remote view, parameterize it so you are only retrieving the data you need to work with. When you open the remote view you can create any index on it you want as long as the table is row buffered. After you create the indexes, you can change the buffering to table if you want. If you use index tag, the index will disappear along with the temp dbf file when you close the view.
>
>The only way that I know how to change the buffering is with CURSORSETPROP() but when I try a CURSORSETPROP I get a error message
>
>Views require either DB_BUFOPTROW or DB_BUFOPTTABLE.
>
>But I can't find a single reference to DB_BUFOPTROW or DB_BUFOPTTABLE in the foxpro help section
>
>am I just totaly letting something slip right by me?

cursorsetprop('buffering', DB_BUFOPTRECORD, 'myview') && row buffering
index on ... tag ...
cursorsetprop('buffering', DB_BUFOPTTABLE, 'myview') && table buffering

In my FoxPro.h file, DB_BUFOPTRECORD is defined as 3, and DB_BUFOPTTABLE is defined as 5.