Tracy, you are spot on of course. Its the missing comma. Many thanks (AGAIN)
On Tue, Jun 30, 2015 at 5:23 PM, Tracy Pearson <tr...@powerchurch.com> wrote: > > > On June 30, 2015 12:58:51 AM EDT, Sytze de Boer <sytze.k...@gmail.com> > wrote: > >Hi Tracy > > > >The error comes up with Command contains unrecognised phrase/keyword > >.....and yes......enginebehavior 70 > > > > > >On Tue, Jun 30, 2015 at 4:50 PM, Tracy Pearson <tr...@powerchurch.com> > >wrote: > > > >> > >> > >> On June 30, 2015 12:18:27 AM EDT, Sytze de Boer > ><sytze.k...@gmail.com> > >> wrote: > >> >This has worked fine for many years > >> > > >> >mcols="XD"+ALLTRIM(STR(trcask13)) > >> >SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax, > >> >SUM(ROUND((gross+nontgross)*(&mcols/100),2)) as super, &mcols as > >> >mpercent > >> >FROM palldets ; > >> >WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode > >INTO > >> >TABLE temp > >> > > >> >Why does this give me grief > >> >mcols="XD"+ALLTRIM(STR(trcask13)) > >> >mmvu ="XD"+ALLTRIM(STR(trcask14)) > >> >SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,; > >> >SUM(ROUND((gross+nontgross)*(&mcols/100),2)) as super, &mcols as > >> >mpercent ; > >> >SUM(ROUND((gross+nontgross)*(&mmvu/100),2)) as volsup,&mmvu as > >volp > >> >FROM > >> >palldets ; > >> >WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode > >INTO > >> >TABLE temp > >> > > >> >in this instance, mcols is XD11 and mmvu is XD39 > >> >Both XD11 and XD39 are fields in a table. > >> > > >> >As you can see, I'm simply adding 2 more columns to the temp table > >> > >> Styze, > >> > >> I would first say the group by isn't valid. However, you don't have > >date > >> or cycle in the grouping. This suggests you are not in VFP 9, or you > >have > >> set the engine behavior to be an older version. > >> > >> You showed us code, you didn't share with us the failure symptoms. > >> > >> Tracy > >> > > Styze, > > It could be the missing comma between mpercent and SUM, or the lack of a > space between volsup, and &mmvu. > > Tracy > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity. > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAG1nNy-Ui0c=eio4sd2lan+f_tzhmt2d-4c8s+dfm4-vsjz...@mail.gmail.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.
