At 12:10 PM 3/24/2008 -0400, MB Software Solutions General Account wrote: >David Boatright wrote: This is probably a stupid question butt... If >you add tables (not views) to the data environment how do you get it to >bring just wait is needed and not the whole table. > I suppose you could employ a filter via the SET FILTER command. If it >were me, I'd either create a view or do a dynamic on-the-fly built >cursor.
I've never used tables in the DE of a form (mainly because MS recommended it at one point, so I KNEW I'd get screwed at some point if I did it). But as far as I know, just putting tables in the DE does NOT bring the whole tables down either. It should just be issuing "USE" statements. However, if you're doing something in your DE that causes VFP to do some kind of SQL execution (I'm just shooting in the dark here), it could well be running a massive query without you realizing it. -Charlie _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
