At 05:44 PM 3/24/2008 -0400, Ted Roche wrote: >Have you tried to change the property NoDataOnLoad to .T. for the two tables? > >On Mon, Mar 24, 2008 at 10:16 AM, David Boatright <[EMAIL PROTECTED]> >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.
You can use the DE to open tables that may be used for other code on the Form. For example, you may have a huge "lookup" table. You don't know what to initially display - the user has to type in a couple characters in a text box. So you put the table in the DE. Then after they type a few characters and tab out (or click button or something like that), you could run a query, or specific a specific SEEK() into the lookup table. Sure, VFP would open the table for you if you used SQL, but if you didn't want to use SQL, you'd have to remember to open the table yourself. And, if I understand the DE correctly, if you set it up to be a "private" datasession, it means you can run that form with multi-instances and not have to worry about code from 1 instance of the form affecting record pointers, table availability, etc of any of the tables in the DE. But there are (or were?) downsides to using DE's. I don't know if they got fixed or not - e.g. the actual table that gets opened may not be the one on the network drive if you have a local version in the same directory tree??? Something weird like that. Maybe someone else can chime in as to whether or not that's really a problem any more. I don't use the DE in my projects so I can't say for sure. -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.
