>>CREATE SQL VIEW lv_testview AS ;
>>SELECT Address.ad_city, Address.ad_state, Address.ad_zip, Whstops.wh_id, Whstops.wh_refid;
>>FROM hits!whstops ;
>>LEFT OUTER JOIN hits!consigne ON Whstops.wh_conid = Consigne.o_id;
>>LEFT OUTER JOIN hits!address ON Consigne.o_id = Address.ad_id ;
>>WHERE Whstops.wh_id = ?vp_id
>>
>>
>>If I issue: USE lv_testview NODATA it pulls about 10MB worth of data over the network.
>
>Definitely odd behaviour. But you could set VP_ID to a non-existant ID [like 0] and see what happens.
I thought the same thing. Tried it. Didn't make a difference. The scary thing is this behavior occurs for every view I've looked at. This seems to be inherent to VFP rather than something specific to this view.
If anyone who works on a network is interested in looking for themselves Win95 comes with a net monitor protocol. It can be found in the Admin/Network/Netmon directory of the win95 disk. To install it go to your network neighborhood properties, click add protocol, click have disk and point it to the netmon directory. This will install the protocol. To view net statistics bring up the win95 system monitor (usually found under start/programs/accessories/system tools) and choose add chart. You should see "Network Monitor Performance" as a category. I've found this useful for diagnosing all sorts of bottlenecks.