>Are we missing something? If you're using a VIEW of a table on the server then the answer is 'YES' the whole table gets brought over.
>
>To avoid this, you should use SQLEXEC to query the server.
Why? When you use a local view (p-view, I mean), it's identical to running SELECT ... Into Cursor ... NOFILTER, and will take about the same time. SELECT itself does not bring up whole table, though NOFILTER clause may involve difficulties with DELETED() tag index, exactly as it was reported here. However, these difficulties never raise to the level of moving up whole tables.
Edward Pikman
Independent Consultant