At 11:30 AM 3/22/2010 -0500, Stephen Russell wrote: ... >You can dance around all you want singing your little song but you >never addressed why you woudl do this on a one by one basis and not >via group by in SQL?
Your sql code will not point out clients that don't yet have a record. And note that nowhere did I say that I would not do the SQL code. I simply showed another alternative that is available for investigation since they have the power of VFP at hand instead of SQL only. > > I bet it's driving you INSANE that the world is still on TCP/IP. > >No Charlie it is not. Odd. You seem inconsistent. You called my alternative approach a "throwback". That, in the context of technology, usually is a criticism that something is obsolete. And you didn't offer a technical criticism of ISAM but basically implied it was "old". So it seemed to me that you generally consider "old" stuff as obsolete (that is certainly what MS marketing usually portrays). TCP/IP is certainly quite "old." > > At the end of the day, no matter what project you're working on, it's > > always good to attack a particular challenge from multiple angles. You'll > > end up with the best result in the long run. I was just providing a > > potentially different angle. Again, I know it's not the MS-way, but it is > > the responsible thing to do. They used to teach this concept in software > > engineering colleges - did you miss that class? >-------------------- ... >Sorry but this is poor design outside of localized data. Will not >scale to alternate backends. Will not work for non int keys. So >where was your engineering class, A.C.M.E. U? Hmmm.... I'm not looking at the original post directly at the moment, but I recall it was a VFP system/database. I suppose you hate VFP with a passion and want to avoid it where possible (why are you still here again?). But recognizing what is available is a sign of proper analysis. If he would have mentioned he needs to port to a different data store, or if he had to interface with some SQL DB then yeah, I probably would not have offered my alternative. Maybe I didn't read the original message right - and maybe for his particular situation the SQL approach will work better <shrug>. At least he has something try. And surely you're not so dense as to see how the approach is easily adapted to char vals, date vals, etc - I just used Integer for brevity (and the fact that IDs are usually integer types). Anyway, yeah, my general computer science/engineering education came from University of Missouri-Rolla (which is now calling themselves Missouri University of Science and Technology). In my day it was known as the 'flunk-you-out' school - which gave it a good reputation for producing good engineers. My advanced degrees were from The George Washington University. From both of those places I was challenged to ignore marketing trends and understand the actual basis of software functionality. But if you think I'm stupid, don't impinge the honor of the schools - I'm sure I don't readily recall as much as I'd like to from those days where cramming for the next test was the norm. -Charlie _______________________________________________ Post Messages to: ProFox@leafe.com 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/5.2.0.9.2.20100322124905.0146d...@incoming.verizon.net ** 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.