Charles, Could you write a program which creates a cursor with some sample data and post it here and let us know what the expected output is and I'm sure one of us will be able to give you the working code
"Charles Hart Enzer, M.D., FAACP" <[email protected]> wrote: >Dear Frank: > >Thank you. > >The SELECT also gives the [Unrocognized Command] error: > > *SELECT Gluctmp1.date, SELECT COUNT(Gluctmp1.amount) FROM GlucTmp1 > GlucTmp2 WHERE GlucTmp2.Date BETWEEN GlucTmp1.Date AND GlucTmp1.Date > + 20); ** > ** FROM Gluctmp1; ** > ** WHERE ; ** > ** Gluctmp1.category = "Glucos"; ** > ** GROUP BY Gluctmp1.date > * > >So I changed it to: > > *SELECT ; > Gluctmp1.date AS Rollingdate, ; > COUNT(Gluctmp1.amount) AS Totals ; > FROM Gluctmp1; > WHERE ; > Gluctmp1.category = "Glucos"; > AND Gluctmp1.amount in ; > (SELECT ; > COUNT(Gluctmp1.amount) ; > FROM GlucTmp1 ; > WHERE GlucTmp1.Date BETWEEN GlucTmp1.Date ; > AND GlucTmp1.Date + 20 ); > GROUP BY Gluctmp1.date > > * > >And got an empty Cursor. > >-- *Charles* -- >Website: http://homepages.uc.edu/~enzerch/ ><http://homepages.uc.edu/%7Eenzerch/> >*"Medicine is a science of uncertainty and an art of probability" >*William Osler, M.D. > >***Stop **Spammers**and **Virus Propagation*** > >***Before **forwarding**, please **delete**the history of all email >address*** > >On 5/1/2013 5:09 PM, Frank Cazabon wrote: >> SELECT Gluctmp1.date, SELECT COUNT(Gluctmp1.amount) FROM GlucTmp1 >> GlucTmp2 WHERE GlucTmp2.Date BETWEEN GlucTmp1.Date AND GlucTmp1.Date >+ >> 20); >> FROM Gluctmp1; >> WHERE ; >> Gluctmp1.category = "Glucos"; >> GROUP BY Gluctmp1.date > > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[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.
