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. > Same as with views - you run queries against the table. Views are nothing more then permanent queries.
I'm assuming you want to minimize table io, so when using tables, you need to avoid inadvertantly selecting all: Use Table && No records are being pulled - OK. Select * from mytable where custid = "123" && Good - only data for customer pulled. Select Amount, due date, custName from mytable where custid = '123' && Better -only needed data pulled. Bad: Browse && basically same as "Select * from mytable) Go Bottom && Has to pull all records to get to bottom _______________________________________________ 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.
