> I will respectfully disagree with those who will say use SET > ENGINEBEHAVIOR 70. >
I use it all the time for my code. There are some pretty cool things I can do Quick, Dirty & Simple using 70 that I find needlessly restrictive or tedious in 90. And the way I use 70 I do not seem to run into any unusual results. For some of my apps I am still compiling in VFP7, as I do not need or want to put my clients through the grief of uninstalling/reinstalling just to get the VFP9 runtime and support files registered on their machinery. But I do code in VFP9, using care to SET ENGINEBEHAVIOR 70 and to not use any commands or syntax from VFP8/9. All my newer stuff is VFP9, and I often use SET ENGINEBEHAVIOR 70 to get the results I need. Works fine, less restrictive, despite not being pure and pristine. Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mike yearwood > Sent: Wednesday, June 18, 2008 8:06 AM > To: [EMAIL PROTECTED] > Subject: Re: SQL Select - you think for me, I have a head cold. > > > Hi Alan > > I will respectfully disagree with those who will say use SET > ENGINEBEHAVIOR 70. > > Off the top of my head and not tested... > > Select ; > PayTable.employeecode, > maxperiod.maxperiodcode as periodcode; > From paytable ; > INNER JOIN ; > (SELECT ; > employeecode, ; > max(periodcode) as maxperiodcode ; > from paytable ; > group by employeecode) maxperiod > on maxperiod.employeecode = paytable.employeecode ; > Order By employeeco > > > Message: 7 > > Date: Wed, 18 Jun 2008 11:15:54 +0100 > > From: "Alan Bourke" <[EMAIL PROTECTED]> > > Subject: SQL Select - you think for me, I have a head cold. > > To: [EMAIL PROTECTED] > > Message-ID: <[EMAIL PROTECTED]> > > Content-Type: text/plain; charset="us-ascii" > > > > VFP=9 SP1 > > EngineBehavior=90 > > > > I have a table with employeecode, period, pay, tax. > > > > The period is in the form '200803' for 2008 period 3. > > > > I want one row for each employee, for the latest period available for > > that employee, with the pay and tax fields. > > > > Which is easy enough to start: > > > > Select employeecode, Max(periodcode) as periodcode From paytable Order > > By employeeco Group By employeeco > > > > ... but once I add the pay and tax fields it wants them in the GROUP BY > > as well. This is undoubtedly simple but the pixies* are kicking the > > inside of my head and I can't think. > > [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/[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.
