In a previous thread for a related topic, the clear concensus was that Parameratized Views are better than the FILTER command. I have three (simple?) questions about View's vs Filter that I can not locate documentation on.

1: I am writing for a shared environment. I thought (from FP2.6) that SELECT (or any other SQL) could not be used in a networked/shared environment because it required Exclusive access. I created a test and noticed that the EXCLUSIVE property in my TESTVIEW was set to YES but my tests on my LAN seem to indicate that this is not a problem. I think EXCLUSIVE in this case relates to the VIEW, which is specific to each machine and therefore does not cause a problem (i.e. the use has exclusive access to a file(view) which is only on their machine anyway). Are there any networking issues I should be aware of with SELECT?

2: As almost everyone has pointed out, it appears that the p-view is very fast. Is it faster that FILTER in all/most parent/child circumstances or is it just faster for grids? Basically, I am trying to decide if I should adjust the code for five large and complex main forms I already have written.

3: I found that unless I set SEND SQL UPDATES on in the View Designer, that the updates did not get sent to the base table. I was using TABLEBUFFER = 3-OPTIMISTIC ROW BUFFERING, and TABLEUPDATE(.T.) in my SKIPx commands. I think the TABLEUPDATE only updated the TESTVIEW info with its related cursor info. Is there anything I am missing here or is SEND SQL UPDATES the only thing I need to know?