Hi Sytze NoDataOnLoad only applies to views, not to tables. The idea is that USE VIEW will cause all records in the table the view references to be downloaded - which can be very time consuming.
In older VFP SQL SELECT * FROM TABLE1, TABLE2 WHERE TABLE1.FIELD1 = TABLE2.FIELD1 AND TABLE1.FIELD2 = 'SOMETHING' In newer VFP SQL SELECT * FROM TABLE1 ; INNER JOIN TABLE2 ON TABLE2.FIELD1 = TABLE1.FIELD1 ; WHERE TABLE1.FIELD2 = 'SOMETHING' The issue of joining the tables is removed from the where clause - I find this far easier to read and maintain. Mike Yearwood > Message: 8 > Date: Wed, 10 Oct 2007 19:31:59 +1300 > From: "Sytze de Boer" <[EMAIL PROTECTED]> > Subject: Re: Is there a difference on how data is handled in VFP9 vs > VFP5? > To: [EMAIL PROTECTED] > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > Hi Folk > I am curious re 2 points mentioned in this thread, but can find no > reference in help file > 1 no data on load, what is this?? > 2 can someone show example of "inner join" versus "where" > > Sytze > > > _______________________________________________ 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.
