*snip*
>
>Why is the row buffering an advantage when indexing the view?
If a view is table buffered, VFP won't allow indexing.
>
>
>>>2. Is the view results stored on the local machine or in the actual db? Can two users have the view open with different results at the same time?
>>
>>The results are stored on the local machine, either as a cursor in memory or on disk. VFP handles this, so you don't have to worry about it. Yes, multiple users can open a view at the same time, all with different results.
>>
>>There is a problem with views though, in that the view record in the DBC is temporary locked when the view is opened. If two users are opening the view at the same time, one may fail. So many developers put their views in a separate DBC, and keep that DBC on the local machine. So there is one DBC on the server for the tables, and each user has their own copy of the view DBC.
>
>Is this only when the view is opened - not requeried?
>
I don't believe so because the view structure is already known and getting that information from the DBC is not necessary.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao