Tracy Pearson wrote: > For large datasets with 32bit guid keys there can be a performance boost > using the .null. in the sub-select. > I've not seen a dramatic increase otherwise.
Ok, I guess we are short-circuiting the need to evaluate field types and the like that will just get thrown away once the subselect does its job. > The second command threw the error, and would expect odd things like that. I'm coming back to VFP after several years from MySQL and SQLite, both of which allow: select NULL as a valid sql statement. It returns a single row, with NULL as the value. So it initially surprised me that VFP didn't allow that. Not that it's useful or anything... -- pkm ~ http://paulmcnett.com _______________________________________________ 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.
