Holy Smoke! Such pedantry over one innocent question. If you can step down off the pedestal for a moment, for some perspective: This is one SQL statement in a nearly 8,000-line conversion program. It is a quick cross-check of information derived by other means. Enginebehavior pops to 70 for this one query, and right back again.
Or maybe I am just lazy. You pick. __stephen already did, Ed wants to pile on. Ken On Feb 16, 2009, at 5:45 PM, Ed Leafe wrote: > On Feb 16, 2009, at 1:10 PM, Stephen Russell wrote: > >> You can get the wrong data when you don't lay out your group bys >> properly. > > > The point is that the wrong data isn't needed. Only a few fields are > used; they just want to be able to type 'select *' instead of having > to specify the fields they actually need. VFP's 70 behavior allows for > such sloppy coding when you don't care if you pull unneeded data > across the lines. > > > -- Ed Leafe > > > > [excessive quoting removed by server] _______________________________________________ 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/bbfaa8a9-5d11-442e-84fc-a40ab2d81...@information-architecture.com ** 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.
